Sort a range

[kevin carter]

Hi,
We have two columns containing formulas(243 in each column)
What we want to do is sort this data in to a top 5 without having to
move or alter the formulas :- ie display the top 5 elsewhere leaving
the original columns(formulas) and rows intact

Can this be done with the mimimum of formulas(eg 5) or VB code


thanks in advance

kevin

 

[Dave Peterson]

Maybe you could just apply Data|Filter|Autofilter.

then use the "top 10" (you can adjust the top and 10 portions).

If that doesn't work for you, how about adding another column. Then take a look
at the =rank() worksheet function in excel's help.

Then sort by that column.

If you want to read more about Ranking, visit Chip Pearson's site:
http://www.cpearson.com/excel/rank.htm