|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 27th, 2006, 01:48 PM
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Chart -- Source Data... -- Series dialog window | Sarah Jane | Charts and Charting | 2 | January 24th, 2006 10:27 AM |
| Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
| SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
| How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
| Having both the date and total of series data displayed underthe data | Jon Peltier | Charts and Charting | 0 | April 14th, 2004 08:39 PM |
Linear Mode
