Posted to microsoft.public.excel.misc
|
|
Return Top Ranks For Certain Categories in Column
Works great, thanks!
"Max" wrote:
how do I modify your second formula so it ranks in
ascending order moving down the column
(similar to your orignal formulas),
instead of across?
Just change: COLUMNS($A:A)
to this: ROWS($1:1)
in the top cells' formulas
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SteveC" wrote in message
...
Max, that works great! thanks.
One more question... how do I modify your second formula so it ranks in
ascending order moving down the column (similar to your orignal formulas),
instead of across?
I tried modifying your original formula with the exact references that on
the actual spreadsheet, but I obviously did something wrong, and I can't
figure out what it is...
Thanks a lot for your help.
SteveC
|