assign a number to the same date & start over with 1 on new date
 

I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?

assign a number to the same date & start over with 1 on new date
 

In B2: =IF(A2="","",COUNTIF(A$2:A2,A2))

copy down as far as needed


"Barbara" wrote:

I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?

assign a number to the same date & start over with 1 on new da
 

Wow! I don't understand why that works - wish I did. But I sure appreciate
the assistance! Thank you SO much!!

"Teethless mama" wrote:

In B2: =IF(A2="","",COUNTIF(A$2:A2,A2))

copy down as far as needed


"Barbara" wrote:

I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?

assign a number to the same date & start over with 1 on new date
 

see your other post

--
Biff
Microsoft Excel MVP


"Barbara" wrote in message
...
I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over
at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?