MAX function

A

Asif

How do you search through an entire worksheet (the formula resides in another worksheet) to find the largest number with the MAX function?

Thanks.
 
B

Biff

Hi asif,

Here's one way:

=MAX(Sheet2!1:65536)

This formula would reside on Sheet1 and return the max
value in Sheet2.

Biff
-----Original Message-----
How do you search through an entire worksheet (the
Click to expand...
formula resides in another worksheet) to find the largest
number with the MAX function?
 
G

Gord Dibben

Asif

Assuming sheet1 with formula and sheet2 with numbers.

On sheet1 enter =MAX(sheet2!1:65536)

Gord Dibben XL2002
 
Top