Calculating Difference two rows based on same ID

twildhart

I have a table of data of Actuals vs Planned results. 

What I would like to do is calculate the delta of Plan vs Actual and sort by the worst delta in the last month. 

Then the output looks like the following with the last month sorted by the the worst Delta so I can identify the place I need to focus. 

test_output.xls

binu_acs

@twildhart One way of doing this with the batch macro

SameID.yxmc

RowBased_230323.yxmd

RowBased_230323.yxzp