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.