retrieve data

  • Thread starter Thread starter pinmaster
  • Start date Start date
P

pinmaster

In column A I have NAMES and in column AB I have a TOTALS column, what
want to do is retrieve to another part of the work sheet the top 10 i
the TOTALS and the corresponding name in the NAME column!....I'm new a
this so I hope I don't sound stupid
 
Hi
try the following
in D1 enter the formula
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,ROW())$B$1:$B$100,0))
in E1 the formula
LARGE($B$1:$B$100,ROW())
copy both down
(Note: you will get wrong results if there are duplicates in this top
10)
 
Hi
small correction for D1:
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,ROW()),$B$1:$B$100,0))
 
Frank said:
*Hi
try the following
in D1 enter the formula
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,ROW())$B$1:$B$100,0))
in E1 the formula
LARGE($B$1:$B$100,ROW())
copy both down
(Note: you will get wrong results if there are duplicates in this
top
10)
Click to expand...

Thanks it works great,
but it only seem to work if I put the starting cell a the very top of
the work sheet, how do I get to work anywhere?
 
Hi
you have to change the second parameter of LARGE: ROW(). A more
generich formula:
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,ROW()-starting_row+1)$B$1:$B
$100,0))
and
LARGE($B$1:$B$100,ROW()-starting_row+1)

just repalce 'starting_row'
 
Thanks again, it's just what I was looking for!......that's gonna mak
my job a lot easier, I really apreciate it a lot!

Jean-Guy
New-Brunswick, Canad
 
Back
Top