ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Start & End of the data series (https://www.excelbanter.com/excel-worksheet-functions/96340-start-end-data-series.html)

0-0 Wai Wai ^-^

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




All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com