This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Went with my favourite multi-row formula as well
My ranking solution varies quite a bit to the proposed solution; I have used fewer tools and no join or summarise. I prefer to work with formulae however a rank tool would have made life much easier!
I used two different approaches to creating the ranking system; the first way is the tile tool, and the second way is the multirow tool. Which one do you like best?
I noticed many similar methods! I'm still getting used to the multi-row formula tool, but I eventually got it to work. :)
A similar solution to the answer compared to some of the other suggestions... Lots of options on this one!
I have to echo Sean Adams on this one! Same solution as @Rachel_Burge, but seems @mceleavey has the right idea with the tile tool. We live and learn...
Rank got me a bit but solved it using multi-row tool.
My method was a little longer than the thread solution, but it works :)