Author Archive | Michael Rempel

How Changing Formats Will Result In Different Sums of Time In Excel

In this tutorial we will review how different time formats will change the view of the results when you are adding a list of cells with time, and could give you what appears to be incorrect answers.

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.