How to ask excel to refer to column title

[Umbaste]

Hello. First of all, I wish to offer an apology, since I'm not sure of how best to word my question, so I went with the best terms I could imagine. Now then, my question goes like this: I have something like this data range, detaling how many times two people eat ice cream flavors.

	A	B	C
1		Vanilla	Strawberry
2	Adam	3	5
3	Barry	6	2
4	Adam's favorite flavor is
5	Barry's favorite flavor is

In this case, how can I make excel detect the larger number for each person and then display the title of the correct column on b4 and b5?

 

[Peter_SSs]

Something like this?

22 04 04.xlsm
	A	B	C	D
1		Vanilla	Strawberry	Favourite
2	Adam	3	5	Strawberry
3	Barry	6	2	Vanilla
4	Jill	4	4	Vanilla, Strawberry
Column Titles

Cell Formulas
Range	Formula
D2:D4	D2	=TEXTJOIN(", ",1,FILTER(B$1:C$1,B2:C2=MAX(B2:C2),""))

 

[RoryA]

You basically need MAX to get the largest value, then use something like HLOOKUP, INDEX/MATCH or XLOOKUP to find that and return the relevant header. For example:

=INDEX($B$1:$C$1,match(MAX($B2:$C2),$B2:$C2,0))

will return the header for Adam. Copy down for Barry.

 

[Umbaste]

Ah. Thank you both for giving me good solutions. Yes, this was exactly what I was looking for, and I wish there was a way to mark both answers as correct. Thanks to both of you all the same.

 

[Peter_SSs]

You're welcome.

Is it not possible that a row could have more than one equal maximum value? Or is it just that if that happens you are happy to only get the first column header that matches that maximum value?

 

[Umbaste]

I thank you once more for your suggestion and your concern, but the actual dataset uses fractions of a decimal, so it's not a likely scenario. Even if it happens, just the fact Excel can detect two different factors as of equal value in the set is more than enough to provide the data I need.

 

[Peter_SSs]

OK, thanks for the clarification.