Please help.
I have an equation below that work great except when row 2 has a duplicate value. When this happen row 5 only return the first value in row 1 and not the other duplicated values.
=INDEX($B$1:$AF$1,MATCH(SMALL($B$2:$AF$2,COLUMN(B$1)-1),$B$2:$R$2,0))
Pleas see attachment. How can I have row 5 return the following value: B5 = A, C6 = B and D5 = C.
Thanks in advance
Bookmarks