Jason,
That works great! The "array-entered" hint is especially appreciated.

"Jason Morin" wrote:

One way:

=ADDRESS(MAX(IF(MAX(D6:CC280)=D6:CC280,ROW(D6:CC28 0))),MAX
(IF(MAX(D6:CC280)=D6:CC280,COLUMN(D6:CC280))),4)

Array-entered, meaning press ctrl + shift + enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
How to determine which cell a value is returned from.
e.g.=MAX(D6:CC280)
returns 525 - How do I find the cell where it occurs?
.