Repeating a date difference formula to groups of varying size.

Hi All I need help developing a formula that I can repeat down a column of approximately 3000 entries. I am attempting to find the difference between the top date and following dates for each group populate in column A and have the formula repeat accordingly.

The problem I am having is that my basic formulas don't recognize groups or varying group sizes and adjust accordingly. When attempting this myself I've noticed that my formulas repeat and do not account that a group may have have more than 2 entries and there is a blank present. I've attached a test spreadsheet.
Any help is appreciated, hopefully this will save me hours of manual calculations. Thanks

Hello
Try the following formula from A3 down on your sample file. Does this do what you're looking for?

Please Login or Register  to view this content.

Hope this helps.
DBY

Thanks for the post, first off the formula you provided is much cleaner than the DATEDIF fx I was using. It still lacks the component of subtracting from the top row in the group as opposed to how it currently subtracts from the row directly above it. The problem only presents itself in groups greater than 2.

Much appreciated. cp

Actually I am referring to the top row of the group, not column C. That is the source of my troubles...besides user error...

cp

Sorry CP
I'm struggling to think of a solution at the moment, I'll get back if I can think of anything. Hopefully another forum member might have a solution.

DBY

No worries, thanks for your time.

cp

Hello again
Not sure if you're still looking for a solution but take a look at the attached file. It uses a helper column but maybe it does what you're looking for.

DBY

Thanks DBY this is perfect. I almost look forward to the next report I can use it on.

cp

@ cput

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.