Find the greatest number in different cells in different worksheets

  • Thread starter Thread starter Yan
  • Start date Start date
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!
 
=MAX(Sheet1!A1:A21,Sheet2!A1:A8)

--


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

Regards,

Peo Sjoblom
 
Back
Top