Removing Duplicate Returns on Calculations (Not Duplicate Lines)

I am working on a file that shows status of items. As items progress through steps of the process, they move to a new status. I need to calculate the time that an items spends in each step.

Unfortunately my data also shows, as a new line, if updates were made in a step before it moves to the next step. Ex: While in the "test" step for item ID AAA, I updated a note to indicate progress was made. The data returns a line for this update, but the step remains unchanged and the entry date to and subsequent exit date from this step also remain unchanged.

I would like to return "0" for instances that just show updates in steps, with no movement. In these instances, the ID, process step, entered queue date, exit queue date are all the same, however the notes are different.

I have attached a file which is representative of my data file.

Thank you for your help.

TeamO

Hi dlfak, thank you for the response. While I think this would satisfy the visualization of the data, I'm wondering how to create a calculation that returns "0" for the 2 occurrences of duplicate status (defined by same unique ID, same status, same entry and exit time).

I do want to count multiple occurrences in a queue, however I want eliminate those that meet the duplicate parameters I have defined.


Perhaps I missed it in your attachments, if so I apologize.

Hi,

I think this is what you're after:

Formula in G2 copied down:

Formula:

Please Login or Register  to view this content.

See attached sample.