Index and Match duplicate results - How to show duplicate names?

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.

Perfect, thank you!

Hi

For Bottom 10 results
Try this for prices

Formula:

=INDEX($AD$1:$AD$900,RIGHT(TEXT(AGGREGATE(15,6,($AD$5:$AD$29+ROW($AD$5:$AD$29)/1000000000),ROW($A1)),"0,000000000"),6))

and this for names

Formula:

=INDEX($AB$1:$AB$900,RIGHT(TEXT(AGGREGATE(15,6,($AD$5:$AD$900+ROW($AD$5:$AD$900)/1000000000),ROW($A1)),"0,000000000"),6))

For Top 10 results
Try this for prices

Formula:

=INDEX($AD$1:$AD$900,RIGHT(TEXT(AGGREGATE(14,6,($AD$5:$AD$29+ROW($AD$5:$AD$29)/1000000000),ROW($A1)),"0,000000000"),6))

and this for names

Formula:

=INDEX($AB$1:$AB$900,RIGHT(TEXT(AGGREGATE(14,6,($AD$5:$AD$900+ROW($AD$5:$AD$900)/1000000000),ROW($A1)),"0,000000000"),6))

Note: Row 1 in some references are not mistake as in INDEX($AD$1:$AD$900...