Hi,

I have two columns... Column AB with product names and column AD with a prices. I need to have a Top 10 and Bottom 10 results. The information in both column AB and AD will change frequently. Right now I have the following:

Top 10 Results 

Pricing (starting in AM5) 

=LARGE($AD$5:$AD$900,1)
=LARGE($AD$5:$AD$900,2)
=LARGE($AD$5:$AD$900,3)

and so on through row AD14

Product Name (starting in AN5)

=INDEX($AB$5:$AB$900,MATCH(AM5,$AM$5:$AM$900,0))
=INDEX($AB$5:$AB$900,MATCH(AM6,$AM$5:$AM$900,0))

and so on through row AN14
Same code for the bottom 10 just with =SMALL in columns AP5 and AQ5

This works great except every so often there is a duplicate price, and when that happens the first product name is listed for all the duplicate prices. I've tried all the examples I can find and nothing seems to work in my situation so I'm not sure what I'm missing.

When there are duplicate prices I need each individual product name to show.

Any help would be greatly appreciated.