it treats those ties as consecutive values, so the order of the list define 1st, 2nd, etc. One way to address this is to combine it with the UNIQUE function like LARGE(UNIQUE(data), k). These vids cover UNIQUE function: th-cam.com/video/TNx4LbVA-iI/w-d-xo.html th-cam.com/video/yTHfw1zMDNM/w-d-xo.html
What if there are ties?
it treats those ties as consecutive values, so the order of the list define 1st, 2nd, etc. One way to address this is to combine it with the UNIQUE function like LARGE(UNIQUE(data), k).
These vids cover UNIQUE function:
th-cam.com/video/TNx4LbVA-iI/w-d-xo.html
th-cam.com/video/yTHfw1zMDNM/w-d-xo.html
For the Name you could simply use Xlookup instead of that ancient Index Match formula!
Yes! Now how could I have forgotten about XLOOKUP😂