| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return rating of which number is highest and descending in column
i have a large amount of numbers in a column, i want to keep them in the same
order, but in the column next to it i would like the rating of which is the highest, which is second highest and so on. hope you can help me |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return rating of which number is highest and descending in column
Assumes your numbers in A1 - A15 put this in B1 and drag down
=RANK(A1,A$1:A$15) Mike "andemor" wrote: i have a large amount of numbers in a column, i want to keep them in the same order, but in the column next to it i would like the rating of which is the highest, which is second highest and so on. hope you can help me |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return rating of which number is highest and descending in column
Also try this,
Put 1 to 15 in A1 to A15 Put Mike's formula in B1 and This formula in C1 =LARGE(A$1:A$15,ROW()) Drag both formulas down to row 15 Now change the data in column A and watch the difference in the in their returns. HTH Martin "andemor" wrote in message ... i have a large amount of numbers in a column, i want to keep them in the same order, but in the column next to it i would like the rating of which is the highest, which is second highest and so on. hope you can help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Summing & return highest value | New Users to Excel | |||
| Adding Column and removing highest number | Excel Discussion (Misc queries) | |||
| In a column of numbers, how do I return the last non-zero number? | Excel Discussion (Misc queries) | |||
| Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
Linear Mode
