| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MIN/MAX Multiple worksheets
How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN/MAX Multiple worksheets
=min(Sheet2!A1,Sheet3!A1,......................... .........................................)
Dave R wrote: How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN/MAX Multiple worksheets
=MIN('Title of sheet'!cell range,repeat for all sheets)
"Dave R" wrote: How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN/MAX Multiple worksheets
Try this:
=MIN(Sheet1:Sheet50!A1) =MAX(Sheet1:Sheet50!A1) -- Biff Microsoft Excel MVP "Dave R" wrote in message ... How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN/MAX Multiple worksheets
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 "kpt" wrote: =MIN('Title of sheet'!cell range,repeat for all sheets) "Dave R" wrote: How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN/MAX Multiple worksheets
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 "Mike" wrote in message ... 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 "kpt" wrote: =MIN('Title of sheet'!cell range,repeat for all sheets) "Dave R" wrote: How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
| Need Simple List...Multiple Columns and Multiple Worksheets | Excel Worksheet Functions | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
![Dave R[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
