Forum Discussion
Solved
X Lookup returning multiple matches
Hi. I'm trying to show a list of placings, i.e. 1st, 2nd, 3rd, etc. but when there are more than 2 with the same amount, it puts that person twice. How can I fix this so it shows the correct placings...
I would change the structure and then do a pivot table.
But I also included a formula solution.
I would change the structure and then do a pivot table.
But I also included a formula solution.
oh yeah, of course. Why didn't I think of that! Thankyou