I have a spreadsheet with categories in columns and samples in rows. I need to get the top three categories for each sample. It's quite similar to the question asked in this recent thread asking for the top 5 items, and the answer given there, =INDEX(A:A,MATCH(LARGE(U:U,ROW()-1),U:U,0)), almost works for me with a little modification, except that it fails when there are duplicate values (it returns the first one twice). My values range between 0 and 1, and in many cases, there will be two cells with a value of 1. It seems I need a VBA program or an array function to do this for me, but I only sort of understand how to use array functions and I know virtually nothing about how to use VBA.
Can anyone help?
Bookmarks