Thread: SMALL(?)
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default 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.