Forum Discussion
Matt_Hicks
Feb 04, 2023Copper Contributor
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...
PeterBartholomew1
Feb 04, 2023Silver Contributor
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)