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

--
TouchTone Support

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

=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"


"TouchTone" wrote:

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

--
TouchTone Support