Type the max number title in Excel

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 by narikkadan
• 63,600 points
530 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 Kithuzzz
• 38,000 points

Related Questions In Others

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

answered Oct 31, 2022 in Others by narikkadan
• 63,600 points
14,674 views
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

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
685 views
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

answered Nov 15, 2022 in Others by narikkadan
• 63,600 points
604 views
0 votes
1 answer

How to change the default number format in Excel?

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

answered Dec 17, 2022 in Others by narikkadan
• 63,600 points
6,685 views
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

answered Nov 4, 2022 in Others by narikkadan
• 63,600 points
1,564 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,427 views
0 votes
1 answer

Multiple IF statements in Excel not working

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

answered Nov 12, 2022 in Mobile Development by narikkadan
• 63,600 points
526 views
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

answered Dec 23, 2022 in Others by narikkadan
• 63,600 points
846 views
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

answered Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
1,268 views
0 votes
1 answer

Reference Excel sheet number in an external workbook

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

answered Mar 17, 2023 in Others by Kithuzzz
• 38,000 points
404 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP