ExcelBanter - Grading Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Grading Values (https://www.excelbanter.com/excel-worksheet-functions/162053-grading-values.html)

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

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

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