Max value in same cell across ALL worksheets
Hi!
=MAX(First:Last!I12)
Where First is the name of the first sheet tab and Last is the name of the
last sheet tab. Any sheets that are in between will be included in the
formula reference.
Biff
"Corey" wrote in message
...
What would be formula to look for the [Max] value in say cell "I12" ACROSS
ALL worksheets with a workbook ?
Currently if i use the MAX formula i get a result of the current worksheet
only.
Corey....
|