Formulas

Follow this simple INDEX MATCH Google Sheets guide to learn how to use this powerful function combo like a pro. ...
Learn everything you need to know about using the Google Sheets SWITCH function with this easy to follow guide....
The Google Sheets IF THEN Formula is actually just called the IF function. Check out our detailed guide to learn everything you need to know about it....
Importing XML data is easy when you use the IMPORTXML Google Sheets function. Follow this simple guide to learn how it works....
Learn everything about the CONCATENATE Google Sheets function in this easy to follow guide, including how its superior to the CONCAT function and why....
Learn the main Google Sheets count unique values methods with a step-by-step guide where I will use each method to extract different values from a sample table. ...
Learn how to use the VLOOKUP Google Sheets function with examples and details on everything you need to know, including syntax and usage. ...
The XLOOKUP Google Sheets function is the best search function for many purposes. Learn how to use it here....
This article explains all the possible methods to do running total in Google Sheets, with step-by-step instructions and lots of examples. ...