Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Start & End of the data series
Is it possible to do the following: When I paste this formula beside the data series, it detects: - the upper & leftmost cell as the start of the data series. - the lower & rightmost cell as the end of the data series. Eg: There are 2 data series, separated by empty cells: First data series: A1 to C5 Second data series: E2 to J7 When I paste the formula beside the data series, it will detect automatically. =sum(detect_data_range) =sum(A1:C5) =sum(detect_data_range) =sum(E2:J7) Thank you! -- Additional info about my computer: - Office XP - Windows XP Pro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
How do I bring a certain data series to the front | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |