| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating cell range depending on input value | Excel Worksheet Functions | |||
| Auto copy data rows between sheets depending on date entry | New Users to Excel | |||
| Select a Range of column depending on the date | Excel Worksheet Functions | |||
| Date Auto-detect & format Issues | Excel Discussion (Misc queries) | |||
| Auto-detect range size | Excel Programming | |||
Linear Mode
