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...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
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 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 251 Formula Unique List within Unique List


See how to create a Unique List of Customers within a Unique List of Sales Reps using a series of standard Formulas and Array Formulas. See the functions COUNTIF, SUMIF, IF, ROWS, INDEX, SMALL, ROW. See how to create a unique List with in a unique list using an ampersand Concatenating formula.





Got a Question? Ask it Here in the Forum.