Simplifying Formula (Part 2)
 

Similar to my last post.
Imagine a pivot table (or one that looks exactly the same using Sumproduct)
and on another page, taking information and sorting it. I currently use.

Name - Think Being Sorted - Rank - Countif - Total - Name - Numbers -
Vlookup - Vlookup

So I rank the data, the countif counts if that data is repeated, so if 2
people both have 14 units, it'll put a 1 next to the second one
(Countif($B$2:B4,B5) dragged down) add the rank and the total together so I
have a rank that doesn't contain multiples. Reput the name, in the next
column just the numbers 1, 2, 3 etc. Then do a Vlookup using those numbers
against the Total column, returning the name; so this puts all the names in
order. Then a final vlookup on the first two columns to get the data next to
the names.

So 9 Columns to automatically sort a column of information, which seems alot
to me... there must be an easier way to automatically sort information
without resorting to using a macro...