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
Bookmarks