How To Increase A Date By One Each Time A Block Of Unique Values Repeats In Excel

In this tutorial we are going to write a formula that allows us to increase the dates in a column by one every time a block of unique values repeats.

How To Convert Oddly Formatted Data Into Dates In Excel

In this tutorial we are going to look at two ways to convert dates that are formatted in odd ways, for example using commas or periods to separate the month, day, and year, to a format that uses the forward slash, which is more traditionally used in Excel.

How To Insert A Blank Row At Each Change In A Column In Excel

In a previous post I talked about how to insert a line at each change in a column of a table or data range in Excel. In this tutorial we’ll look at how to insert a blank row at those changes.

Use Conditional Formatting To Insert A Line At Each Column Change In A Table In Excel

In this tutorial we are going to use Conditional Formatting to show two ways that we can draw a line in a table at each change in the list of a specific column of that table. One method will draw a thin line, the other will make that line much bolder.

How To Calculate Hotel Reservation Nights For An Event In Excel

This tutorial came from a recent request on how to calculate the number of room reservations needed each night for an event. I came up with two solutions, one using the IF and AND functions, and the other using COUNTIFS.

Some Unique Uses of INDEX and MATCH Functions In Excel

In the past we’ve used the combination of INDEX and MATCH to extract the value of the intersection of a row and column of a data range. But there is more that you can do with this function combination, and we’ll look at those options in this tutorial.