Excel Forum

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

Got a Question? Ask it Here in the Forum.