excel question

[Pradeep Pradhan]

hi,

i have attached one file. In the file there are some mix used in product with corresponding weight given in the other columns of same row. I want to extract the mix which has maximum weight among all other mix shown in a particular row.

Pls help.

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[Pradeep Pradhan]

Hi ,

See if this is what you wanted.

Narayan

Thanks a lot .Yes that is ok. i want corresponding wt of that mix in another column also

 

[Pradeep Pradhan]

Thanks a lot for solutions. rest i can manage