Excel Forum
Similar Content
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 ...
Naming Cells in Excel to Make Using Formulas/Functions Easier
Tutorial: In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell w...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...



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.