Forum Discussion
Ranking in Excel
RichardBeavers The XLOOKUP errors I found are in columns V and W.
I think I follow you now - suggested formula in the attached.
Hi Savia
Many thanks for your reply.
Ultimately I am looking to achieve a ranking for (Top 5 only) the data in Column AB
This Ranking should relate to the Date Course and Time of the race. Ignoring Zeros and without skipping numbers (where Duplicates) but only showing Top 5 where any rating above that is then a Blank. Not much to ask Eh! (LOL)
eg,
| Date | Meeting | Time | |||
| 01/03/2020 | Huntingdon | 14:20 | 103 | 2 | |
| 01/03/2020 | Huntingdon | 14:20 | 103 | 2 | |
| 01/03/2020 | Huntingdon | 14:20 | 88 | 3 | |
| 01/03/2020 | Huntingdon | 14:20 | 0 | ||
| 01/03/2020 | Huntingdon | 14:20 | 133 | 1 | |
| 01/03/2020 | Huntingdon | 14:20 | 0 | ||
| 01/03/2020 | Huntingdon | 14:20 | 0 | ||
| 01/03/2020 | Huntingdon | 14:20 | 0 |
p.s not Sure where the Xlookup mistake is that you refer to is it in a particular column. Probably more mistakes than that given my brain is 70 years old (Almost)
RichardBeavers The XLOOKUP errors I found are in columns V and W.
I think I follow you now - suggested formula in the attached.
Hi Savia
I have corrected the Xlookup Errors as you advised.
Still not sure how to get it to 1,2,2,3 Instead of 1,2,2,4
regards
Richard
Should have asked you a week ago.
Many thanks I will correct the Xlookup Errors
Your Formula is great. Is there any way for it to do the same without skipping numbers Savia.
i.e. 1,2,2,3 instead of 1,2,2,4
regards
Richard