Excel Magic Trick 251 Formula Unique List within Unique List

Описание: Download Excel Start File: h https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
Full Page With All File Links: https://people.highline.edu/mgirvin/e...

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.