Tag: Google Sheets
-
Use INDEX with MATCH functions for a more dynamic Excel Lookup
INDEX and MATCH function are close cousins to the VLOOKUP function and their combination creates a more flexible and better lookup function.
-
How to Perform a Weighted Average Calculation in Excel
A weighted average calculation takes into account some numbers should influence the average more than others. I typically find myself needing this calculation when working with data that is already summarized in a table.
-
Import CSV Data to Google Sheets from Gmail using Google Apps Scripts
Save yourself time by using this script to automatically pull data from a CSV file you receive as a Gmail attachment into a Google Sheet. I find this script especially useful when working with CSV files I receive on a recurring basis.
-
Using Variable Fields in Google Sheets QUERY Function
Make the Google Sheets QUERY function even more flexible when you add variable parameters to your query.
-
How to use OR Logic with the FILTER Function
By default, the FILTER function in Google Sheets is set up to take multiple criteria using AND logic. With a slight modification, you can make it use OR logic.
-
Why do my dates appear as 43,000 numbers in excel? Here’s how to fix that
Incorrect number formatting in a cell can cause your cell to appear as something totally different and it can be so frustrating. Dates can sometimes appear as numbers and it’s easy to think you are going crazy. Here’s how to fix it.
-
How to pull external data from a website into Google Sheets
Google Sheets has an awesome formula that automatically pull data from a website. This can be a huge time saver especially if you manually pulling data frequently.
-
Repeat an item in Excel X number of times
In this post, I’m going to walk you through how to take a list of items and repeat each list element X number of times to create a longer list.