If you want to remove duplicates and transpose your data with a single formula in Google Sheets, you can do this by combining the UNIQUE function with the TRANSPOSE function. In this lesson I am going to show you multiple ways of combining these two functions, so that you can […]

If you want to filter your data and transpose it with a single formula in Google Sheets, you can do this by combining the FILTER function with the TRANSPOSE function. The FILTER function will allow you to filter your data by specific criteria, and the TRANSPOSE function converts columns to […]

If you want to sort and transpose your data with a single formula in Google Sheets, you can do this by combining the SORT function with the TRANSPOSE function. These two functions can be used together in a variety of ways, from sorting data that is converted from columns to […]

If you want to remove duplicates and filter your data with a single formula in Google Sheets, you can do this by combining the UNIQUE function with the FILTER function. In this lesson I am going to show you multiple ways of combining these two functions, so that you can […]

If you want to remove duplicates and sort your data with a single formula in Google Sheets, you can do this by combining the SORT function with the UNIQUE function. In this article I will show you multiple ways of combining these two formulas so that you can remove duplicates […]

Did you know that there is a Google Sheets formula that will allow you to convert from one currency to another? The GOOGLEFINANCE formula allows you to convert currencies, and stays up to date with changing conversion rates. For example, if you want to convert from U.S. Dollars to Euros, […]

Have you ever wanted to divide in your spreadsheet without a remainder, where the answer is a whole number? There are several ways to do this, depending on which function you want to use, and depending on if you want to round up, round down, or round according to normal […]

Have you ever needed to find the lowest number that is divisible by two (or more) given numbers in your spreadsheet? Google Sheets has a formula that will allow you to do this very easily. In this lesson I will show you how to use the least common multiple functions […]

Have you ever needed to find the highest number that would divide into two (or more) given numbers in your spreadsheet? Google Sheets has a formula that will allow you to do exactly that, very easily. In this lesson I will show you how to use the greatest common divisor […]

If you have numbers in your Google spreadsheet that you need to round, this lesson will teach you all of the different ways to round numbers in a spreadsheet. I will teach you how to round to the nearest whole number, how to round up or down to a specified […]

When you are dealing with time values and durations in Google Sheets, you will often need to convert between duration, number of hours, minutes, and seconds. This is something that I needed to do frequently when I was managing data and building dashboards for an online high school, since the […]

In Google Sheets you will sometimes have the need to calculate the amount of time between two different times (time difference), such as when you want to calculate how long a job shift is, or when you want to calculate the time that has elapsed given two times. This can […]