numbers more than once
 

Good day,
Please help with the following.
If I do a Top 3 list and it shows up as follows

A B
1 my
2 try
3 by
4 guy
2 sigh
The moment that a number in A appears more than once it picks only one name
and not both names under 2 as required.

numbers more than once
 

Are you using the Data-Sort function?

"ekkeindoha" wrote:

Good day,
Please help with the following.
If I do a Top 3 list and it shows up as follows

A B
1 my
2 try
3 by
4 guy
2 sigh
The moment that a number in A appears more than once it picks only one name
and not both names under 2 as required.

numbers more than once
 

Try this one line ARRAY formula (entered using ctrl+shift+enter) where col L
has the names and col K has the numbers. Enter is row 1 and copy down

=INDEX($L$1:$L$15,MATCH(TRUE,$K$1:$K$15+ROW($K$1:$ K$15)/1000=LARGE($K$1:$K$15+ROW($K$1:$K$15)/1000,ROW()),0))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ekkeindoha" wrote in message
...
Good day,
Please help with the following.
If I do a Top 3 list and it shows up as follows

A B
1 my
2 try
3 by
4 guy
2 sigh
The moment that a number in A appears more than once it picks only one
name
and not both names under 2 as required.