Count all equal highest values in a row.

[pittsburghr2]

I have a formula that identifies the highest absolute value in a row of data:

=MAX(-MIN(A1:DSB1), MAX(A1:DSB1))

However there are always several cells in the row that all have the highest value. Since there are so many rows it's not easy to identify the cells accurately. I'd like to AT LEAST be able to have an accurate count of the cells with the highest value. So if 43 was the highest value in a row and 43 occurred 4 times, I could have a cell at the end of the row display the number 4.

And IDEALLY I would prefer a list of the 4 column names in the row which had the result of 43 but that may be too complicated for me from what I've read on this so far. I'm pretty new to excel.

Thanks in advance for looking.

[sktneer]

May be this.....

Please Login or Register  to view this content.

[Ron Coderre]

With
A1:DSB1 containing column headings: Alpha, Bravo, Charlie, etc
A2:DSB2 containing random positive and negative values

This formula returns the largest absolute value of that range:

Please Login or Register  to view this content.

The count of that value (using absolute values)

Please Login or Register  to view this content.

Listing the matching column headings is not something Excel does easily.
Here's one approach...
this regular formula, copied down, begins the list of headings for matching columns:

Please Login or Register  to view this content.

Is that something you can work with?