Index Match Duplicate Values - ignore cells equal to 0

Hi All,

Im using the following formula;

=INDEX($A1:$H1,MATCH(LARGE($A2:$H2-COLUMN($A2:$H2)/10^10,COLUMNS($A5:A5)),$A2:$H2-COLUMN($A2:$H2)/10^10,0))

I have a row of data of scores ranging from 0 to 4. Some cells have the same score. I am attempting to index match so the highest 2 scores will return the header / corresponding team - without duplicating.

Where I am stuck, I do not want the 0 score to be included in this formula - I dont want in those 2 highest scores for one to be a 0.

How can I manipulate this formula to only calculate scores > 1 ?

Thank you all in advance!

Thanks! Its actually built on that question. The formula there answered my initial question however I need to tweak it to make it ignore 0's

I appreciate the answer however the above formula takes care of the 0's issue. I now need to manupulate the formula to not include 0's found in the dataset.