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

[JBH]

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!

 

[Ragdyer]

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

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

 

[Tom Ogilvy]

Why not just sort your list or use the Top 10 option under
Data=>Filter=>Autofilter

--
Regards,
Tom Ogilvy

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

 

[Harlan Grove]

Why not just sort your list or use the Top 10 option under
Data=>Filter=>Autofilter

...

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.