View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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....