Grading Values

B

build

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
 
B

build

Exactly what I wanted.
Unfortunatley every other word but the word ranking came to mind so my
searches were fruitless.

cheers,
build
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort Columns of data at the same time, without regard to order. 3
find lowest number and return it's adjacent cell 7
Breaking a tie - Excel 2003 5
How to clear the lowest 10 values from a list of 30 values 3
Is there a shorten way to increase the value 1
Finding the weighted average of text that have been given values 1
Calculating current grade percentage 4
Changing GPA to Ltr Grade 8

Top