#1
|
|||
|
|||
Help with a formula
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. |
#2
|
|||
|
|||
=IF(COUNTIFS($B$2:B2,B2)=1,".",A2-A1) should do the trick
|
#3
|
||||
|
||||
As the OP seems to be using 2016, COUNTIFS is not available.
However Purfleet's formula will work with COUNTIF instead |
#4
|
|||
|
|||
Countifs has been around for years? Its showing on my work PC (2016) and my old excel 2007 box
|
#5
|
|||
|
|||
Thanks Purfleet, that worked perfectly!!!
|
#6
|
||||
|
||||
Microsoft then has it wrong COUNTIFS function - Office Support
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
Better formula please | Haha88 | Excel | 2 | 03-01-2015 03:36 PM |
What formula should I use? | TotalONE | Excel | 3 | 11-26-2013 01:30 PM |