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

B

Barbara

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?
 
B

Barbara

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

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

Need help with formula to count the number of times each date appe 3
Count the number of dates less than a given date 1
Count based on multiple criteria 2
Beyond the VLOOKUP Limitation: Extracting records after the 1st re 3
Counting number of rows between date range and meeting 2 string criteria 11
count on 3 criteria 3
lookup based on date range 4
How do I spread numbers over several months? 3

Top