Hello Good People,
Im trying to create a continuos aging report.
Basically heres the problem.
Daily, Im extracting application numbers from multiple workbooks.
Those application are pending and daily extraction, if that application number status is not yet approved then it will continue pending in the workbook source.
So when I extract the next day, that application will still appear pending..
Not sure If I explain it clearly but heres my workbook below.
B column Date is Minus to G column Date today,..
I wanted to have a aging report by mainting my original pending date whhich is the first touch. 11may 22 eliminating duplicate value until the status become Approved.
B C D E F G
Im trying to create a continuos aging report.
Basically heres the problem.
Daily, Im extracting application numbers from multiple workbooks.
Those application are pending and daily extraction, if that application number status is not yet approved then it will continue pending in the workbook source.
So when I extract the next day, that application will still appear pending..
Not sure If I explain it clearly but heres my workbook below.
B column Date is Minus to G column Date today,..
I wanted to have a aging report by mainting my original pending date whhich is the first touch. 11may 22 eliminating duplicate value until the status become Approved.
B C D E F G
Date | APP ID | Status | Aging (Days) | 24-May-22 | |||
11-May-22 | 123 | Pending | 13 | ||||
12-May-22 | 123 | Prev Pending | 12 | ||||
13-May-22 | 123 | Prev Pending | 11 | ||||
16-May-22 | 123 | Prev Pending | 8 | ||||
17-May-22 | 123 | Prev Pending | 7 | ||||
18-May-22 | 123 | Approved | Done |