MAX function

  • Thread starter Thread starter Asif
  • Start date Start date
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.
 
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?
 
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
how copy formula that contains ranges so ranges do not overlap 1
How to return the text data of the first col after getting the max value from the 2nd col 1
Min/Max of Numbers as Text 8
Is this function supposed to work? 6
How do I find top 3 in an unsorted list? 3
What's causing error message? 4
Identify the row in which a MAX number in a column resides 7

Back
Top