Griddy / Blog
Spreadsheet how-tos.
Step-by-step guides for Excel and Google Sheets formulas, data cleanup, charts, and more — and how Griddy handles each one in seconds.
Page 6 of 7 · 76 posts
How to Concatenate in Excel (Join Text from Multiple Cells)
Three ways to combine text from multiple cells in Excel: the & operator, CONCAT, and TEXTJOIN — with examples for names, addresses, and delimited lists.
Excel IF Statement with Multiple Conditions: AND, OR, IFS, and SWITCH
Write Excel IF formulas with multiple conditions using AND, OR, nested IF, IFS, and SWITCH. Includes practical budget and review examples.
Excel INDEX MATCH: The Better Alternative to VLOOKUP
INDEX MATCH can look up values in any direction, never breaks when you insert columns, and handles multiple conditions. Here's how it works and when to use it over VLOOKUP.
How to Use XLOOKUP in Excel
XLOOKUP is the modern replacement for VLOOKUP — it can look in any direction, handles missing values cleanly, and doesn't break when columns shift. Here's how it works.
How to Remove Duplicates in Excel
Three ways to find and remove duplicate rows in Excel: the built-in tool, COUNTIF to flag them first, and UNIQUE for a clean deduplicated list. Plus what to do when duplicates are hiding.
How to Sort Data in Excel
Sort Excel data alphabetically, numerically, by multiple columns, or by custom order. Covers the Sort button, the SORT function, and how to avoid the most common sorting mistake.
How to Fix the VLOOKUP #N/A Error in Excel
The #N/A error in VLOOKUP means the lookup value wasn't found. Here are the six most common reasons and exactly how to fix each one.
How to Make a Pivot Table in Excel
Pivot tables let you summarize thousands of rows into a clean report in seconds. Here's how to build one from scratch, customize it, and avoid the most common mistakes.
How to Use Conditional Formatting in Excel
Conditional formatting highlights cells automatically based on rules you set — values, text, dates, formulas. Here's how to set it up, use formula-based rules, and manage rules that conflict.
Excel Date Formulas: TODAY, DATE, DATEDIF, EDATE, and More
The essential Excel date functions: get today's date, calculate days between dates, find end-of-month dates, add months, and count working days — with examples for each.
How to Make a Drop-Down List in Excel
Create data validation dropdown lists in Excel from a manual list, a cell range, or a named range — plus how to make dependent dropdowns where the second list changes based on the first selection.
How to Use VLOOKUP in Excel
VLOOKUP finds a value in a table by searching the first column and returning a result from another column. Here's exactly how it works — and when to use XLOOKUP instead.