Summarise table data and use lookup functions in Excel

Summarise your data easily in Excel. Pull all unique items out of lists, count how many of each type of item there are, and build in conditions to make your spreadsheets smarter. 🏢 I use these formulas every day. They save a lot of time and effort. I've added timestamps below so you can skip to the one you need quickly: 0:00 Intro and dataset 1:02 UNIQUE - get a list of all unique items in a given range 1:56 COUNTA - count non-blank cells in a range 2:33 COUNTBLANK - count non-blank cells in a range 2:47 COUNTIF - count cells in a range that match a condition 4:42 SUMIF - sum cells in a range that match a condition 7:19 VLOOKUP - lookup a value in a vertical table given a different value 8:52 HLOOKUP - lookup a value in a horizontal table given a different value 9:50 XLOOKUP - lookup a value in anytable given a different value 11:53 MATCH - find item in given range 📊 Data set link: https://drive.google.com/file/d/1QulO7DmBuAT_h9ZpmPVsglOPaVOwJ2j3/view?usp=sharing