Return top three headers with the highest values (some with the same value)

Hello all, this is my first post and I am looking to solve a issue I am having.

I have a row with values in them, some being exactly the same. These values have different header names but I cannot get a return of the different header if it so happens to be the same value as the one furthest to the left.

For example: From the data below, I want to return, l Green l Red l Brown l in three different cells. If there is no data I want the cells to remain blank.

Red l Green l Brown l Orange
2 l 4 l 2 l 0


Any help would be appreciated. TIA

example1.jpg



Not sure if that will work but this is what I am working with.

Attachment 497966



Not sure if that will work but this is what I am working with.

A common way of doing this to use "helper" rows or columns

in E2:

=A2+(COUNTIF($A2:A2,A2)-1)*0.01

Copy across to H

in I2

=INDEX($A$1:$D$1,MATCH(LARGE($E$2:$H$2,COLUMNS($A:A)),$E$2:$H$2,0))

copy across to K

If you use this technique you can place the "helper" cells anywhere "out of sight"