Forum Discussion

RichardBeavers's avatar
RichardBeavers
Copper Contributor
Apr 08, 2020
Solved

Ranking in Excel

I hope you are all well and avoiding the nasties as we are here in Scotland.  I am at an impasse with one thing however. I have a file that I use for horse racing stats. I have a Formula to ranks th...
excel
Savia's avatar
Savia
Iron Contributor
Apr 08, 2020

RichardBeavers Could you explain what you need to do and where a little more?  I can't quite follow.

 

One thing I immediately noticed - your XLOOKUPs refer to a range that has no $s in it - that means that as you copy the XLOOKUP downwards, the lookup and return arrays are also moved downwards, which will cause errors.  Try e.g. N$4:N$500.

  • RichardBeavers's avatar
    RichardBeavers
    Copper Contributor
    Apr 08, 2020

    Savia 

     

    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,

     

    DateMeetingTime  
    01/03/2020Huntingdon14:20 1032
    01/03/2020Huntingdon14:20 1032
    01/03/2020Huntingdon14:20 883
    01/03/2020Huntingdon14:20 0 
    01/03/2020Huntingdon14:20 1331
    01/03/2020Huntingdon14:20 0 
    01/03/2020Huntingdon14:20 0 
    01/03/2020Huntingdon14: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)

Resources