Not to hijack this post too much, but could this formula below be modified to look up column headings instead of row values? I have a table with values from E:IQ, and would like to find the top ten values in that list (including multiple duplicates) and return the column heading associated with those values. Essentially trying to return the "names" of the columns associated with the top 10 values in a row, which are duplicated multiple times.

Thanks in advance,

Matt


[quote=Domenic;393259]
Provided that Column Q contains numbers that do not exceed 10 digits in
length, try...

=INDEX(A2:A290,MATCH(LARGE(Q2:Q290-ROW(Q2:Q290)/10^5,2),Q2:Q290-ROW(Q2:Q2
90)/10^5,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!