D
Dave R
How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook?
a single workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
=min(Sheet2!A1,Sheet3!A1,..................................................................)
K
kpt
=MIN('Title of sheet'!cell range,repeat for all sheets)
T
T. Valko
Try this:
=MIN(Sheet1:Sheet50!A1)
=MAX(Sheet1:Sheet50!A1)
=MIN(Sheet1:Sheet50!A1)
=MAX(Sheet1:Sheet50!A1)
T
T. Valko
Try this:
=MIN(Sheet1:Sheet50!A1)
=MAX(Sheet1:Sheet50!A1)
=MIN(Sheet1:Sheet50!A1)
=MAX(Sheet1:Sheet50!A1)
M
Mike
I have the same problem i tried these formulas but i geat a ref error, need
to know how to do this all my sheets reads 0 for the cell im using until data
is entered so i have tried =min('Week 1:Week 52'!,w265 & get a ref error also
tried >0 with this & still the same
to know how to do this all my sheets reads 0 for the cell im using until data
is entered so i have tried =min('Week 1:Week 52'!,w265 & get a ref error also
tried >0 with this & still the same
P
Peo Sjoblom
You could use 2 dummy sheets called something like First and Last or Start
and End then add all the future sheets in-between those 2 sheets and use a
formula like
=MIN(Start:End!W265)
--
Regards,
Peo Sjoblom
and End then add all the future sheets in-between those 2 sheets and use a
formula like
=MIN(Start:End!W265)
--
Regards,
Peo Sjoblom