Index Match, repeated numbers

Hi

There are various posts on this site that give solutions on how to make repeated rankings unique. If you can get the common rankings solved, would that solve your problem?

If not, then one thing you could do is a count of the ranking. If it comes back with > 1, then you would have to find all the items and output them as required. It would be a lot easier for us to provide a solution if we could see an example of how your data is structured, so if the first options isn't suitable, then attach an example file for us to review.


rylo

Hi Rylo,

Here is the file for you to review. As you can see the last few ranks are the same but it returns only the first match. If you could help me with this that would be great.

Cheers mate,

Tony

Tony

Using your example workbook.
sheet2!AB146:

Please Login or Register  to view this content.

This formula is array entered - hold down the ctrl and shift keys, then press enter.

Copy the formula down to AB155.

rylo