Excel Forum
Similar Content
Generate a Unique List of Random Numbers With a Simple Formula + (GUID/UUID Generator)
Tutorial: Sections: GUID/UUID V4 Formula in Excel Versatile Formula to Generate a Unique List of N...
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...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.