Maximum match column

[Pinang]

Hi,

I need to find maximum match from column and return column heading in result. Attached sample excel file with example.

Thanks in advance.

 

[John Jairo V]

Hi @Pinang!

Check file, with this formula applied:
=IFNA(LOOKUP(1,0/(A2:D2=G2),A$1:D$1),"")

Blessings!

 

[bosco_yip]

Another formula approach, criteria data may not be at the same row of Group Table, pls see below:

1] Define Name:



2] In H2, formula copied down:

=IF(1-ISNA(MATCH(G2,INDEX(GroupTable,,MaxColNum),0)),INDEX(CroupHeader,MaxColNum),"")

3] See attachment

 

[Peter Bartholomew]

Similar defined names to @bosco_yip but using the most recent functions.

= BYROW(groupTbl=data, LAMBDA(crit,
    XLOOKUP(TRUE, crit, groupHdr, "", ,-1)
  ))

The matching headers are returned as a single dynamic range.

 

[Pinang]

Th

Hi,

I need to find maximum match from column and return column heading in result. Attached sample excel file with example.

Thanks in advance.

Thanks