SMALL(?)
Ron de Bruin wrote:
You can use the LARGE function in combination with Vlookup
A1:A10 are numbers
B1:B10 are names
=VLOOKUP(LARGE(A1:A10,1),A1:B10,2)
Change the 1 to two if you want the second biggest
Thanks, this answer my question, but my question was badly answered.
What I need isn't fulfilled by this. I get the same "bad names" as I get
with the other response I got. Besides I'd need to reorder the columns,
because I have A:A = Names B:B = Numbers, not as VLOOKUP expects it.
Thanks anyway Ron.
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.
|