Option 1 was VBA.
Option 2 delivers results in separate cells (again an array formula, copied across and down):
=IFERROR(INDEX($F$1:$H$1,SMALL(IF($F2:$H2=MIN($F2:$H2),COLUMN($F2:$H2)-COLUMN($F2)+1),COLUMNS($I:I))),"")
Option 3 delivers results in a single celll (again, an array formula copied down: set for up to 3 minimum values):
Formula:
=IFERROR(INDEX($M$1:$O$1,SMALL(IF($M2:$O2=MIN($M2:$O2),COLUMN($M2:$O2)-COLUMN($M2)+1),1)),"")&
IFERROR(", "&INDEX($M$1:$O$1,SMALL(IF($M2:$O2=MIN($M2:$O2),COLUMN($M2:$O2)-COLUMN($M2)+1),2)),"")&
IFERROR(", "&INDEX($M$1:$O$1,SMALL(IF($M2:$O2=MIN($M2:$O2),COLUMN($M2:$O2)-COLUMN($M2)+1),3)),"")
see sheet for context.
Obviously, if you go for one of the formula versions, save as .xlsx,rather than .xlsm
Bookmarks