A Asif Nov 7, 2003 #1 How do you search through an entire worksheet (the formula resides in another worksheet) to find the largest number with the MAX function? Thanks.
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 Nov 7, 2003 #2 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?
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 Nov 7, 2003 #3 Asif Assuming sheet1 with formula and sheet2 with numbers. On sheet1 enter =MAX(sheet2!1:65536) Gord Dibben XL2002
Asif Assuming sheet1 with formula and sheet2 with numbers. On sheet1 enter =MAX(sheet2!1:65536) Gord Dibben XL2002
