Excel Forum
Similar Content
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...



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.