Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D range problem
I need to calculate standard deviation for data located on multiple
worksheets. The problem is that the number of worksheets changes from time to time. I want the calculation to automatically adjust to include data from the third worksheet up however many worksheets there are in the workbook at the time. Searching for ways to do this leads me to believe there were "get.workbook()" and "get.document()" functions in older versions of Excel that can be used in Define|Names, but I can't find a reference for the arguments (I do know that (76) gives current sheet name, and (87) gives current sheet position). Any thoughts on how to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D range problem
if it is a common range in each worksheet, try
insert a worksheet before Worksheet 3 Name it "Start" add a worksheet after the last worksheet Name it "Last" =stedev(Start:Last!range) insert any new worksheets between Start and Last "br549" wrote: I need to calculate standard deviation for data located on multiple worksheets. The problem is that the number of worksheets changes from time to time. I want the calculation to automatically adjust to include data from the third worksheet up however many worksheets there are in the workbook at the time. Searching for ways to do this leads me to believe there were "get.workbook()" and "get.document()" functions in older versions of Excel that can be used in Define|Names, but I can't find a reference for the arguments (I do know that (76) gives current sheet name, and (87) gives current sheet position). Any thoughts on how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with range | Excel Discussion (Misc queries) | |||
Range Problem | Excel Discussion (Misc queries) | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions |