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.
Riny_van_Eekelen sorry, I have now added other relevant data. hopefully this helps
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