Ranking a number within a range (not an exact match)...

[jacksparrow22]

Hi guys

I have a number that I'd like to see ranked within a separate range. Ie if the number is 25 and I want to see how it would be ranked if it were in a range of:

3
43
12
19
22
7
88

(The answer would be 3 - 3rd highest).

Any ideas? The RANK formula requires an exact match...

 

[JoeMo]

Hi guys

I have a number that I'd like to see ranked within a separate range. Ie if the number is 25 and I want to see how it would be ranked if it were in a range of:

3
43
12
19
22
7
88

(The answer would be 3 - 3rd highest).

Any ideas? The RANK formula requires an exact match...

Excel Workbook
	A	B	C	D
1	3		myNum	25
2	43		Rank	3
3	12
4	19
5	22
6	7
7	88
Sheet17

 

[Matty]

Maybe:

=COUNTIF(A2:A8,">"&25)+1

Matty