Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formula to count the number of times each date appe
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formula to count the number of times each date appe
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) -- Biff Microsoft Excel MVP "Barbara" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formula to count the number of times each date
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. Valko" wrote: 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) -- Biff Microsoft Excel MVP "Barbara" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formula to count the number of times each date
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? -- Biff Microsoft Excel MVP "Barbara" wrote in message ... 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. Valko" wrote: 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) -- Biff Microsoft Excel MVP "Barbara" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the number of times a specific date appears in a range of ce | Excel Worksheet Functions | |||
Count of times a number is repeated by date? | Excel Worksheet Functions | |||
I need a temp to input numbers and get the amount of times it appe | Charts and Charting in Excel | |||
Count Number of Times Q | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions |