Counting Days

Hello,

I am trying to find a formula that will count how long a person is in a certain status. The picture below shows the end result that I am looking for (in column E).

Example1.JPG

I want the formula find the last time a Name appears in the Name column and count how many days it has been in that status.

Any help is appreciated!

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

A simple B2-A2 should do what you want

If you tried to attach a file, it looks like it didnt come through, can you try again?

John - Thank you so much for your help! Your formula works perfectly!

FDibbins - Thank you for suggesting to attach my Excel Document. I will start doing that from now on!

John - Sorry to bother you again. I tried adding onto my worksheet and the formula is not functioning properly now. Could you please explain to me why it may not be working? Is it something that I am not doing correctly?

Try this modification of JohnTopley's formula. It is also array entered.

=IF(MAX(IF($D$2:$D$8=$D2,$A$2:$A$8,""))=$A2,$B2-INDEX($A$2:$A$8,MATCH(1,1/(D2=$D$2:$D$8)*(C2=$C$2:$C$8),0)),"")

Edit By the way ... as I now understand it row 6 (E6) is 5? That's what this formula returns. Am I missing something?

You are welcome. Thank you for the feedback and the rep ... though JohnTopley did the heavy work.