G
Guest
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
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