Difference from previous row in filtered table

[wenter95]

Hi All,

Need someone to shed some light.

Attached image 1 the raw data, where Column A shows different machine ID, Column B shows different date and Column C is my specification respectively.

I'm looking up for a formula in Excel, which can calculate the difference from previous successive row in filtered table, under same condition/criteria (eg. same machine ID and same station date_trackouttime). For example, I filtered with machine ID to BG3 with station date 11/6/2023, track out time sorted in ascending order as in image 2 below, and the difference from its previous successive row will display in Column D. The remaining unfiltered data (other machine ID in same date) should also proceed to display the differences accordingly under the same condition

I know pivot table > shows value as difference from previous will do the same thing, but i need it to be done in raw data table for further analysis.

Thank you.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to calculate difference from previous row in filtered table
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.