I've got a large amount of data that I've sorted with a pivot table. I need
to order the data within each column of the pivot table (outside of the pivot
table).

Example:
Frequency
A 6
B 7
C 6
D 5
E 4

Obviously, the largest number in the frequency column is 7 and obviously,
the next largest number is 6. What I'm trying to do is to get Excel to list
the results by row heading (i.e., B is the largest, A is the next largest, C
is the next largest, etc.) even when there is a duplicate number. I've been
using the =large() function to no avail (it gives me a value of 6 for both
the second and third largest values). How do I get Excel to differentiate
between the two distinct values of "6"?

Thanks in advance,

Jim314