Excel Forum



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.