| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Days after a Start Date | Excel Discussion (Misc queries) | |||
| Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
| Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
| Calculating monthly start date with a start date | Excel Worksheet Functions | |||
| Determining an annual review date from an employee start date | Excel Worksheet Functions | |||
Hybrid Mode
