Forum Discussion
Index Match duplicate return
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 ma...
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
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)