Find the greatest number in different cells in different worksheets

Y

Yan

I will like to know how to create a formulas that can
look for the greatest number in a variety of cells and
worksheet, then inert the greatest of them in another
worksheet


thx you!
 
P

Peo Sjoblom

=MAX(Sheet1!A1:A21,Sheet2!A1:A8)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

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

Creating a template that I can reproduce every month by keying ininformation from SAP 8
Function in Excel to count and list number of entries of text valuesin a row. 2
Greatest Number 11
optimization 1
Formula to enter data of one cell based on greatest amount of anot 1
Excel 2002: How to Select Greater Value of Numerous Cells? 4
Finding the Address of a Cell 5
NEED TO CREATE A CONDITIONAL FORMULA 1

Top