Index Match duplicate return

Copper Contributor

Hi Guys,

 

i have trawled the internet to get this working to no luck, i am a novice at this.

 

I want to create a leader board excel which i am going use in multiple ways for work.

 

i have managed to get an index match to return most of what i need it to, but i want to avoid duplicate return names.

 

where am i going wrong, please can someone help me?   

 

Thank you in advance

 

leaderboard.png

duplicate.png

index match.png

5 Replies

@Matt_Hicks 

Which version of Excel do you have / do you need to support?

@Matt_Hicks 

A not so helpful solution might be to ditch whatever version of Excel you currently us and switch to 365.  Then the formula could be

= SORTBY(HSTACK(name,total),total,-1)
i am using office 365

@Peter Bartholomew 

 

I cant seem to get this to give me any results, just #spill!

 

I should also explain i have another formula to create the leader board aswell.

 

i have a feeling i have over complicated this

 

large.png

@Matt_Hicks 

I am not sure why you should get a spill error unless you are trying to place the result in a table or copy/fill the formula down (the bottom one should still work in the latter case). 

Maybe start by trying

= SORTBY(name, total,-1)