Remove Duplicates in Excel + Data Validation Dropdowns

Real-world data is messy. The same customer appears three times with slightly different spellings, and a column where people were supposed to pick from a list contains twelve creative variations of “Yes”. Two built-in tools fix this: Remove Duplicates cleans the list you already have, and data validation dropdowns stop the mess from happening again. … Read more

IF and IFERROR in Excel: Handle Errors and Make Decisions

Two of the most useful functions in Excel are also two of the simplest. IF makes a decision: if this is true, show that; otherwise show something else. IFERROR catches errors and replaces them with something readable. Together, they turn fragile formulas into spreadsheets other people can actually use. The IF function =IF(logical_test, value_if_true, value_if_false) … Read more

SUMIFS in Excel: Sum With Multiple Conditions

“How much did we sell in the East region in March?” is a question with two conditions, and SUMIF — which handles only one — can’t answer it. SUMIFS can. It adds up only the rows that match all of your conditions, and it takes as many conditions as you need. What SUMIFS does SUMIFS … Read more

XLOOKUP in Excel: The Modern Replacement for VLOOKUP

VLOOKUP has served Excel users for decades, but it has always had sharp edges: it can’t look to the left, it breaks if you insert a column, and it needs FALSE typed every time or it silently gives wrong answers. XLOOKUP fixes all of that. If you have Microsoft 365 or Excel 2021, XLOOKUP is … Read more

How to Use VLOOKUP in Excel (Step by Step, With Examples)

You’re staring at a product code and you need its price. The price lives in another table — maybe another sheet. Typing it by hand works for five rows. It does not work for five hundred. That’s the job VLOOKUP was built for: look up a value in the first column of a table and … Read more