Category: Sheet Functions Posts

In this post we’ll look at how we can remove duplicates from a set of data, with one simple formula using the UNIQUE function. We’ll also use the SORT function to put the unique list in order and use this in a drop down menu using DATA VALIDATION. Finally, we’ll look at counting those entries… Continue reading Google Sheets Functions – UNIQUE, COUNTUNIQUE, SORT

In this post, we’re going to look at how we change the format of text to suit our needs, using the functions PROPER, UPPER, LOWER, and TRIM. It’s particularly useful when working with text that has come from, for example, a form, a different computer system, or indeed someone has typed in on your Sheet.… Continue reading Google Sheets Functions – PROPER, UPPER, LOWER, TRIM

In this post, we’re going to look at how we can count things and add things up depending on certain conditions that we set. There are four functions we’ll look at here: COUNTIF, SUMIF, COUNTIFS, and SUMIFS. Here I’ll show you the various aspects of the functions through some practical examples. Example 1 – COUNTIF:… Continue reading Google Sheets Functions – COUNTIF(S) & SUMIF(S)

Here’s how to look up values in tables in Google Sheets using the really useful VLOOKUP function (Vertical Look up). You give it something to look for in the table and it gets the value you’re after from a different column in that row. As always the best way to show what it does is through… Continue reading Google Sheets Functions – VLOOKUP