- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Ranking a number outside of range's values?

Subject: | Ranking a number outside of range's values? |

Posted by: | pompair (timonar…@gmail.com) |

Date: | 31 Jan 2007 |

Hi

I have in A1:A5 numbers:

7

4

9

1

2

If I write =RANK(7;A1:A5;1) the result is rightly 4. This is the rank

for the number 7 in this range.

But what I'd like to do is to find the rank for some number outside of

the range, like 3 for example, how would I do it?

I mean, trying something like: =RANK(3;A1:A5;1) results in #N/A

Any ideas?

- Re: Ranking a number outside of range's values? posted by T. Valko on Wed, 31 Jan 2007