Returning Top Values
Posted by James on March 02, 2001 7:54 AM
I am still fairly new to Excel and have an interesting question that I hope someone can answer.
Lets say I have a spread sheet containing three columns. Col1 is for Names and Col2 and 3 are for numerical data. Is it possible that on another page that I can display the top 5 values in Col3 as well as the name in Col1 associated with it?
It is sort of like the sort feature except I do not want to sort the data on page 1 and on page 2 I only want the top 5.
Can anyone help with this?
Thank you very much,