To find the address of the max try this

=ADDRESS(MAX(IF(MAX(A1:E8)=A1:E8,ROW(A1:E8))),MAX( IF(MAX(A1:E8)=A1:E8,COLUMN(A1:E8))),4)

Array entered. This is for A1 - E8

Mike

"BarDoomed" wrote:

I am building a worksheet that collects data from a network on a daily basis.
One of the data categories has 9 columns and 8 rows. I am finding the MAX of
each column but need to identify the row in which a MAX number in a column
resides at the same time. Probably pretty simple but for some reason I can't
put it together.

Thanks
DobieG

Why my display named shows up as BarDoomed I don't know?????????