Help with rankings / finding the second occurence of same value in a list

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

Guest

How do I use vlookup to find the SECOND occurence of a value? (Or is there something else I should be using instead?) I can have it lookup the first, but I don't know how to find the second one. Situation: I'm trying to build a top 10 list of product names based on rates of return, and if I have two products with the same rate of return, vlookup only returns the first product with that rate of return, but I need to show both the first and the second (and 3rd, 4th, etc...)
Any help is appreciated!
 
You should be able to revise this post to suit your needs.

http://tinyurl.com/39rtw

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
JBH said:
How do I use vlookup to find the SECOND occurence of a value? (Or is
Click to expand...
there something else I should be using instead?) I can have it lookup the
first, but I don't know how to find the second one. Situation: I'm trying
to build a top 10 list of product names based on rates of return, and if I
have two products with the same rate of return, vlookup only returns the
first product with that rate of return, but I need to show both the first
and the second (and 3rd, 4th, etc...).
 
Why not just sort your list or use the Top 10 option under
Data=>Filter=>Autofilter

--
Regards,
Tom Ogilvy

JBH said:
How do I use vlookup to find the SECOND occurence of a value? (Or is
Click to expand...
there something else I should be using instead?) I can have it lookup the
first, but I don't know how to find the second one. Situation: I'm trying
to build a top 10 list of product names based on rates of return, and if I
have two products with the same rate of return, vlookup only returns the
first product with that rate of return, but I need to show both the first
and the second (and 3rd, 4th, etc...).
 
Why not just sort your list or use the Top 10 option under
Data=>Filter=>Autofilter
Click to expand...
...

Probably for the same reason people tend to use formulas calling VLOOKUP rather
than using AutoFilter to find specific data in lists - because there are times
it's more efficient to use formulas.
 
Back
Top