Auto detect the range depending up on the input date.

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto-input text bx depending on 2 drops	Dispatcher Scott	Microsoft Access Form Coding	4	7th Mar 2009 12:21 AM
Input mask date syntax-limit input to a number range	=?Utf-8?B?QmlsbGlhbQ==?=	Microsoft Access Database Table Design	2	18th Nov 2007 03:37 PM
Select a Range of column depending on the date	Battykoda via OfficeKB.com	Microsoft Excel Worksheet Functions	1	2nd May 2007 08:22 PM
Build a table depending on a date range.	=?Utf-8?B?Q0QgVG9t?=	Microsoft Access Queries	1	2nd Jan 2007 06:39 PM
Offset formula to add range depending on date	Todd	Microsoft Excel Worksheet Functions	3	22nd Nov 2003 06:12 PM