0 votes

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.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```
Apr 2, 2023 in Others 399 views

## 1 answer to this question.

0 votes

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),""))`
answered Apr 2, 2023 by
• 38,010 points

0 votes
1 answer

## 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

0 votes
1 answer

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

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

0 votes
1 answer

## MAX function in Excel: is it possible to provide the range by means of variables?

Try this: =MAX(INDEX(A:A,B2):INDEX(A:A,B3)) READ MORE

0 votes
1 answer

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

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

0 votes
1 answer

## 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

0 votes
1 answer

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

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

0 votes
1 answer

## Multiple IF statements in Excel not working

When you add an IF statement to a formula ...READ MORE

0 votes
1 answer

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

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

0 votes
1 answer

## Excel VBA: Obtain the Column and Row of current element in "For Each" loop

Try this: MsgBox rng.Address(RowAbsolute:=False, ColumnAbsolute:=F ...READ MORE

0 votes
1 answer

## Reference Excel sheet number in an external workbook

Try this: Function SheetByCodeName(wb As Workbook, cn As ...READ MORE