Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grading Values
G'day All,
I have a range of 10 values. I want to evaluate the lowest, second lowest, third ..... etc. For instance I need calculate that no 7 is the fourth(4) lowest number. I cannot use data sort. 1 644 2 326 3 358 4 577 5 882 6 944 7 623 8 688 9 739 10 758 Thanking you in anticipation, build |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grading Values
Look up the RANK function in Excel help
-- David Biddulph "build" wrote in message ... G'day All, I have a range of 10 values. I want to evaluate the lowest, second lowest, third ..... etc. For instance I need calculate that no 7 is the fourth(4) lowest number. I cannot use data sort. 1 644 2 326 3 358 4 577 5 882 6 944 7 623 8 688 9 739 10 758 Thanking you in anticipation, build |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grading Values
Exactly what I wanted.
Unfortunatley every other word but the word ranking came to mind so my searches were fruitless. cheers, build "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Look up the RANK function in Excel help -- David Biddulph "build" wrote in message ... G'day All, I have a range of 10 values. I want to evaluate the lowest, second lowest, third ..... etc. For instance I need calculate that no 7 is the fourth(4) lowest number. I cannot use data sort. 1 644 2 326 3 358 4 577 5 882 6 944 7 623 8 688 9 739 10 758 Thanking you in anticipation, build |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grading | Excel Worksheet Functions | |||
Grading function in Excel | Excel Worksheet Functions | |||
How to find avg, min & max for grading subject | Excel Worksheet Functions | |||
how to write a class row for grading | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions |