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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Vlookup and MAX functions 4
Min/Max of Numbers as Text 8
Is this function supposed to work? 6
How to return the text data of the first col after getting the max value from the 2nd col 1
how copy formula that contains ranges so ranges do not overlap 1
Function for 2nd and third low or Max 2
Identify the row in which a MAX number in a column resides 7
Max Length in a row 1

Top