Large function displays duplicate results

[DAVIDJMORIN]

I am using the attached sheet to get a ranking of most profitable to least using a formula.
=LARGE(PhoneProfit2,L2)

But the issue is say that i have 2 phones with same profit, it duplicates them in the column. I want them to just show the next phone name and profit. Also maybe someone can look at this sheet and see if they know a better way to reference the phone name to the cost using the same logic.

I have attached sheet below

Thank you for the help

[FlameRetired]

Edited formula and attachment.

Your profile shows Excel 2003 yet your upload is a newer file format.

Please update your profile. Many members tailor solution with that in mind.

That said and gambling that you have Excel 2010 or newer please find this in M2 filled down.

Please Login or Register  to view this content.

If I have guessed incorrectly you will need something different.