Formula to Pick largest absolute value and return column header

[bthumble]

Hello,
Need assistance with a formula to return the largest absolute value in a range and return the column heading in row 1. Found this formula on another forum and it works but it only gives me the largest value, not the largest absolute value:

=INDEX($BE$1:$BL$1,MATCH(LARGE($BE2:$BL2,COLUMNS($BR2:BR2)),$BE2:$BL2,0))

I would rather stay away from arrays if possible.

Thanks.

 

[Fluff]

Not sure how to do it without a CSE formula, but this CSE formula should do it
=INDEX($BE$1:$BL$1,MATCH(LARGE(ABS($BE2:$BL2),COLUMNS($BR2:BR2)),ABS($BE2:$BL2),0))