Sorting product row with header result

[Guest]

Dear all

Please advise how do I do the following in Excel.

Supplier1 Supplier2 Supplier3 End Result
Products1 3 1 2 Supplier2 Supplier3 Supplier1
Products2 2 3 1 Supplier3 Supplier1 Supplier2

 

[Guest]

If you only ever have 3 columns of data then with products listewd in ColA,
starting in A2 and supplier names in B11, the following 3 formulae will get
the results you require:

=INDEX($B$1:$D$1,MATCH(LARGE($B2:$D2,1),$B2:$D2,0))
=INDEX($B$1:$D$1,MATCH(LARGE($B2:$D2,2),$B2:$D2,0))
=INDEX($B$1:$D$1,MATCH(LARGE($B2:$D2,3),$B2:$D2,0))
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"