Forum Discussion
How to do INDEX MATCH in table with multiple matches
Hi, I am trying to create a table that is basically showing the top 3 results from a another table with 2 columns. However, I've been running into an issue when the values are the same, as it is only...
FILTER is the right idea but you still have to deal with the potential ties.
This will pull a dynamic top 3:
=LET(
M, SORT(DemoTbl, 2, -1),
total, TAKE(M, , -1),
top, INDEX(UNIQUE(total), 3),
FILTER(M, total >= top)
)Tables are great for data input but don't work with spilling and dynamic arrays.