numbers more than once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
Back
Top