Hello everyone,

Consider an example of sales team. You want to create a report that gives you the largest sale figure, 2nd largest and so on. In addition you are also looking for sales person names but in case there are more than one sales person with same sales figure , how do you make excel treat it as dplicate and just display the name beside the other place holder instead of on a separete row.

Here is a very good tutorial tell you just that. Very nice use of Small and FREQUENCY function