Main Profile

At A Glance

Excel Magic Trick #187: Unique List w Dynamic Formula

Create a unique list of items for a large list that contains duplicates with 2 array formula that contain the functions: SUM, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW Related Videos: Excel Magic Trick #180: COUNTIF function formula 21 Examples 05 Excel Series: Array Formulas 1-14 Various INDEX Lookup w TRUE/FALSE criteria "Reverse Lookup" Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteria Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists Excel Magic Trick 82: Advanced Filter Extract Unique Records
Length: 09:41

Contact

Questions about Excel Magic Trick #187: Unique List w Dynamic Formula

Want more info about Excel Magic Trick #187: Unique List w Dynamic Formula? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question