Forum Discussion
How can I avoid duplicate values being returned with INDEX MATCH?
I'm trying to return the top 10 worst percentages with a LARGE function, and then in an adjacent column, use the INDEX MATCH functions to return which question correspon...
This uses 365. If one sets out to exploit 365 to the full, the resulting formulas tend to be unrecognisable to anyone versed in traditional spreadsheet methods. In this case
= TAKE(SORTBY(table, percentage, -1), 10)That is: sort the entire table by the percentage column descending and select the first 10 rows. For me 365 was worth the investment but then, I was delighted to dispense with concepts such as direct cell referencing (ignoring the 17 billion predefined names) and relative referencing (used to build lists).