Re: SMALL(?)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Beto (beto_z_o.Borra_Esto_at_hotmail.com)
Date: 02/03/04 

Date: Tue, 03 Feb 2004 13:26:34 -0400

Juan Pablo González wrote:

> 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.

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, 

-- 
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.