There a quite a few people who are using Google Sheets to keep track of game stats, which is interesting. Here’s a modified question someone asked. They wanted to know about how to dynamically matching winner scores with initials. I threw in a bit of error-checking to make it cleaner. Click the pic to check out the video.
This is a pretty useful technique about how to extract data from within the cell. If you have numbers and letters mixed together, this video will give you one of the ways to separate them.
SUM, AVERAGE, COUNT and their conditional equivalents are staples in Microsoft Excel and Google spreadsheets. However, there is a seldom-used alternative that allows users to incorporate those functions and a few others in one line: SUBTOTAL. Here’s how it works:Continue reading "SUBTOTAL: A More Mature Alternative to the SUM, AVERAGE & Other Functions"
There are a few lookup functions you can use in spreadsheets. HLOOKUP is one of the more familiar functions, but not many have heard about LOOKUP. It’s a rare function that’s really only useful in one particular task.Continue reading "The Rare Pair: How to Use LOOKUP and HLOOKUP"
Index/Match is a pretty popular formula combination that gives you the ability to move and manipulate data across Google spreadsheets, helping you to get the data you need faster. In order to understand how this works, let’s break things down.Continue reading "Index/Match Formula in Google Sheets with a Quick Example"