Hi all

I have a list of codes and dates that I am trying to count depending on the group number. Within each group is a date. Each time the first group number appears I want a (.) to signify that its the first one in the group, the following lines should add up the amount of days between the previous date within the group. I hope I explained that well enough to understand. I am including an example so that you have an idea of what I am trying to accomplish. Thanks in advance for any and all assistance.

Attached Files

Example.xlsx (9.8 KB, 8 views)

=IF(COUNTIFS($B$2:B2,B2)=1,".",A2-A1) should do the trick

Attached Files

Examplemsof_PURFLEET.xlsx (10.2 KB, 10 views)

As the OP seems to be using 2016, COUNTIFS is not available.
However Purfleet's formula will work with COUNTIF instead

Countifs has been around for years? Its showing on my work PC (2016) and my old excel 2007 box

Thanks Purfleet, that worked perfectly!!!

Microsoft then has it wrong COUNTIFS function - Office Support