SMALL(?)

  • Thread starter Thread starter Juan Pablo González
  • Start date Start date
J

Juan Pablo González

Beto, you can use INDEX (INDICE) after you get the small (K.ESIMO.MENOR) or
large (K.ESIMO.MAYOR) number, something like

=INDEX(A1:A100, MATCH(LARGE(B1:B100,3), B1:B100, 0))

or in spanish:

=INDICE(A1:A100, COINCIDIR(K.ESIMO.MAYOR(B1:B100,3), B1:B100, 0))

where A1:A100 house the names, and B1:B100 the numbers.
 
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
 
Hi, I have a question about this function:

Well it's not exactly that function it's the opposite one (BIG?) I don't
know its name, because in my Excel it's called K.ESIMO.MAYOR.

I have a table with numbers and names and I want the name of the biggest
number, the second biggest, etc... How do I get this through formulas?
numbers may be repeated, but just one would be enough. With
K.ESIMO.MAYOR I can get the biggest number, but now how do I use this in
another formula to get the name? I'm not good with references so can you
help me out?

Regards,
 
Juan said:
Beto, you can use INDEX (INDICE) after you get the small (K.ESIMO.MENOR) or
large (K.ESIMO.MAYOR) number, something like

=INDEX(A1:A100, MATCH(LARGE(B1:B100,3), B1:B100, 0))

or in spanish:

=INDICE(A1:A100, COINCIDIR(K.ESIMO.MAYOR(B1:B100,3), B1:B100, 0))

where A1:A100 house the names, and B1:B100 the numbers.
Click to expand...

Hi,

It's working as it is. It's almost what I need... now the problem arises
when there are two equal numbers, because it will display the same name
for "different" numbers. Let's say I want the Top 5 of the list, I get
the top five numbers (one is repeated) but the associated name is wrong
in one of them... any way to correct this?


Regards,
 
Ron said:
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
Click to expand...

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,
 
Back
Top