Need help with formula to count the number of times each date appe

B

Barbara

I have a column of dates and 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.

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?

Thank you!
Barbara
 
T

T. Valko

Try this...

Assume your dates start in cell A2.

Enter 1 in B2

Enter this formula in B3 and copy down as needed:

=IF(A3=A2,B2+1,1)
 
B

Barbara

That didn't work but I did get an answer that did. Thank you so much for
trying to help - I really appreciate being able to ask the experts!!
 
T

T. Valko

That didn't work but I did get an answer that did.

Hmmm....

Worked just fine for me. Care to explain what didn't work means? Are there
any empty/blank cells within the range?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

assign a number to the same date & start over with 1 on new date 3
Count the number of dates less than a given date 1
Count based on multiple criteria 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
time_report_date-wise_employee-wise 6
IF ARRAY with multiple conditions. 1
Excel date intervals look up 1
Modifying a complex date formual to count months 4

Top