Similar to excel rank?

[Gareth Keenan]

Is there a function I can use to look at an array, and return the rank of the item I'm looking for. For example suppose I have

A,1
B,4
C,6
D,2

I would want to put in a third column that looked at the 1,4,6, and 2 and returns what position in the array the number was. Except in my real world situation the 1,4,6,and 2 are going to be =RAND() functions so I want to click F9, and know if each the B is lowest, C is second lowest etc, and there rank to come in the form of a number. I feel like Excel should have this function somewhere, but it's not INDEX, MATCH, or RANK(It didn't look like rank)

Suggestions?

Gareth Keenan

[llcooljabe]

ARe the letters in the first column, and the numbers in a second and the ranks in a 3rd?

[llcooljabe]

I'm confused as to why you don't use RANK?

[Gareth Keenan]

The reason is because I am a turd fergusson. I've tested Rank, it does what I want.

Is there a delete thread button?