Forum Discussion
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...
RichardBeavers The XLOOKUP errors I found are in columns V and W.
I think I follow you now - suggested formula in the attached.
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.