Return nth value from list

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Matt (anonymous_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 16:21:06 -0700

Hi -

I have a list of values in range b3:b100. I'd like to
return the nth value to cell a2. I was going to use the
rank function in range a3:a100 and then do a vlookup in
cell a2 that looks for the nth rank and returns the value
from col b. That works, but I'd prefer to do the entire
formula in cell a2 - without adding the rank formulas.
Any ideas?

I'm using Excel 97 in Windows 2000. Thanks!

Quantcast