I want two fill land types with columns a, b, c, and d. If A is greater than all 3 types A or if b is greater than A, C, and D then type B or if c is greater than A, B, and D Type C or if D is greater than 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.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
Apr 2 in Others 58 views

## 1 answer to this question.

If you have duplicates and want to list all you could use:

`=TEXTJOIN(",",1,FILTER(\$A\$1:\$D\$1,A2:D2=MAX(A2:D2),""))`

Or:

`=ARRAYTOTEXT(FILTER(\$A\$1:\$D\$1,A2:D2=MAX(A2:D2),""))`
• 38,010 points

## How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## How to change the default number format in Excel?

Excel Tips, Learn Excel \ Raghu R Setting ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE