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.
Author Archive | Michael Rempel
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.
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.
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.
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.
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.