ExcelBanter - Auto detect the range depending up on the input date.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto detect the range depending up on the input date. (https://www.excelbanter.com/excel-programming/437019-auto-detect-range-depending-up-input-date.html)

Auto detect the range depending up on the input date.

Hi All,

I have an excel as below. If I give the date as input, suppose 6/1/2009,
excel should do a count if function with the range starting from the 1st cell
below the input date till the next date in the dates column. I am confused,
please help.
6/1/2009
N New 291420 Roger
N New 291425 Fred
N New 291427 Lisa
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/2/2009
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/3/2009

Thanks,
S

Auto detect the range depending up on the input date.

Where do you give the date as input? In the same sheet? In another sheet?

"SR" wrote:

Hi All,

I have an excel as below. If I give the date as input, suppose 6/1/2009,
excel should do a count if function with the range starting from the 1st cell
below the input date till the next date in the dates column. I am confused,
please help.
6/1/2009
N New 291420 Roger
N New 291425 Fred
N New 291427 Lisa
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/2/2009
N New 291532 Lima
N New 291741 Lisa
N New 291531 Roger
N New 291494 Roger
6/3/2009

Thanks,
S