I want two fill land type with column a , b , c , d. If A is greater then all 3 then type A or if b is greater then A, C and D then type B or if c is greater then A, B and D then Type C or if D is greater then A, B, C then type D in one cell in Excel.enter image description here
CCA Banjar_Kadeem Ghasni Gair_Mumkin Land_Type
0.112 0.000 0.000 0.000 CCA
0.018 0.000 0.000 0.000 CCA
0.177 0.000 0.000 0.000 CCA
0.243 0.000 0.000 0.000 CCA
0.033 0.000 0.000 0.000 CCA
0.056 0.000 0.000 0.000 CCA
0.045 0.000 0.000 0.003 CCA
0.064 0.064 0.000 0.000 Banjar_Kadeem
0.127 0.000 0.000 0.000 CCA
0.040 0.000 0.000 0.000 CCA
0.059 0.000 0.000 0.000 CCA
0.031 0.000 0.000 0.004 CCA
0.000 0.000 0.000 0.005 Gair_Mumkin
0.000 0.000 0.000 0.009 Gair_Mumkin
0.000 0.000 0.000 0.069 Gair_Mumkin
0.167 0.000 0.000 0.000 CCA
0.000 0.000 0.000 0.007 Gair_Mumkin
0.000 0.000 0.000 0.019 Gair_Mumkin
0.014 0.000 0.000 0.000 CCA
0.046 0.000 0.000 0.000 CCA
0.040 0.000 0.000 0.000 CCA
0.048 0.048 0.000 0.000 Banjar_Kadeem
You have indicated all the columns are different, but your sample data has two columns the same.
I assume that the data is incorrect.
This formula will do what you want.
=INDEX($A$1:$D$1,MATCH(MAX(A2:D2),A2:D2,0))
Place in E2 and drag down