Find Duplicates, Then Calculate Date Difference

[wilsoa]

I have three columns:
Status
Date
Name

Is there any way to look at the name, then status, and then calculate the difference (time value) of the dates?

For example:
Status -------- Date ------- Name
Active -------- 1/1/12 ----- Doe
Active -------- 2/1/12 ----- Thomas
Active -------- 2/2/12 ----- Smith
Active -------- 2/15/12 ---- Young
Discharged ---- 3/1/12 ----- Doe
Discharged ---- 3/15/12 ---- Smith
Active -------- 3/16/12 ---- Willis
Discharged ---- 3/18/12 ---- Thomas

So, what I would like to do, is look at the name, find the duplicate, make sure that the status is active (the discharged), and then calculate th difference between the resulting dates in weeks/days.

It should return something like:
Name ------- Duration (in days)
Doe --------- 60
Thomas ----- 46
Smith ------- 42

Thanks in advance!

[dilipandey]

Hi Wilsoa,

See the difference and let me know if this solves your purpose. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[rvasquez]

Hi Wilsoa,

Attached is a spreadsheet I believe does everything you requested.

Thanks!

RVASQUEZ