Return column title based on smallest value by row?

Originally Posted by realrookie

In the real data we have several times where we would get 3 or even 5 results back, so it would be handy

Are you familiar with macros/VBA ?

This can be done with a VBA function. Want to try it?

With your file open, copy the VBA code at this link and paste it into a general module.

https://www.excelforum.com/showthread.php?p=3096647

Then...

Data Range

	A	B	C	D	E	F	G	H	I
1	Name		Test1	Test2	Test3	Test4	Test5		Expected value
2	CAR1		66.7%	40.0%	100.0%	71.4%	50.0%		Test2
3	CAR2		100.0%	20.0%	40.0%	57.1%	16.7%		Test5
4	CAR3		33.3%	0.0%	40.0%	57.1%	0.0%		Test2, Test5
5	------	------	------	------	------	------	------	------	------

This array formula** entered in I2 and copied down:

=concatall(IF(C2:G2=MIN(C2:G2),C$1:G$1,""),", ")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

That sounds like the cell is formatted as text.

Change the cell format to General then re-enter the formula.

Array formulas are entered differently than a regular formula. After you type in a regular formula you hit the ENTER key. With an array formula you must use a combination of keys. Those keys are the CTRL key, the SHIFT key and the ENTER key. That is, hold down both the CTRL key and the SHIFT key then hit the ENTER key.

When done properly Excel will enclose the formula in squiggly brackets { }. You can't just type these brackets in, you must use the key combo to produce them. Also, anytime you edit an array formula it must be re-entered as an array using the key combo.

Here's your file with this implemented.