Don't want duplicate numbers

[FrankHiggins]

Hello every-one

It's my first time on this forum so forgive me if this is on the wrong thread and please redirect me to the right thread.

I'm trying to get the 5 most common numbers in the Irish Lottery, and while I can get the the 5 largest numbers (by using the LARGE formula), sometimes a LARGE value comes up twice and when I use the INDEX/MATCH formula to get the corresponding Ball Number, it only gives me the lowest ball number twice. Is there a formula to get around this?

please find an attachment as it might explain it better.Irish Lottery.xlsx

Thank you in advance

[sktneer]

Hi Frank,
Welcome to the Forum.

Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.

In B58

Please Login or Register  to view this content.

and then copy down.

[FrankHiggins]

Thanks for the prompt and brilliant answer Sktneer. It works a treat. Thanks a million

[sktneer]

You're welcome. Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.