Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help-sorting Data
hi Tom, Sorry for not being clear in what I wanted.. The problem is that these 3 cols form part of a table containing about 9 columns and 10 rows. These are data entered by the user in a data sheet.The user's job is only to enter the data. I have to make excel choose the top 3 values from Column C.This has to be done as a spreadsheet function.The chosen top 3 has to be displayed in a different sheet along with the corresponding data in the other columns. If I use rank on values that have both negative and positive values it does not give me the desired result. So what I tried to do was to convert all the values into positive ones and then I used rank. But the next problem is I have to choose those rows having the ranks 1 , 2 and 3 from the jumbled ranking and display corresponding data. Please help, thanx for the reply, Arvind. -- mnarvind ------------------------------------------------------------------------ mnarvind's Profile: http://www.excelforum.com/member.php...o&userid=15205 View this thread: http://www.excelforum.com/showthread...hreadid=314291 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Sorting | Excel Worksheet Functions | |||
Sorting Data | Excel Discussion (Misc queries) | |||
Sorting Data | Excel Discussion (Misc queries) | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel |