Q:

How to dynamically select a range of cells in excel?

I want to select the range of cells which starts after Test_start and ends before Test_stop.In the sample shown the range to select would be A4:A6,
I have manually selected the range and found the total to be 6 as it should be.
The data will remain in the same column and will always begin with Test_start and end with Test_stop, however it may begin at any row .
If it helps I have only one data set per sheet.
I wish to achieve this using Excel formulas and not vba !!.

A:

=MATCH("test_stop";A:A;0)-MATCH("test_start";A:A;0)+1
You can manipulate the result by adding integers to the result / subtracting them as well.
The formula works properly only for one column.
Cheers.

