Using Macro to flag OK and Not OK by scenario

[emina002]

Hi All,

I know this thing need a macro at all or it is pure formula and function only. I just need to determine or flag an invoice number "OK" and "NOT OK" if met possible scenario, I hope someone out there with great minds can help me.

1. For example and invoice number has PD1 to PD7 is over 90 days. It should flag as OK
2. For example and invoice number has PD1 to PD2 is over 90 days. It should flag as OK
3. Note that if invoice number has only 1 PD and is over 90 days. It should flag as OK
4. If an invoice also has 3 PD's(eg: PD4-PD6) and all is over 90 days, it should flag as OK.

5. If Invoice number 31-60 days has value on PD6 and 61-90 days on PD7 has value but 1-30 has no value it should tag as NOT OK on invoice SI1 8427 (see possible scenario on workbook attach)

6. If it is skipped or duplicate it will tag as NOT OK. For this sample see workbook attach and refer to SCENARIO tab, actual data was on PIVOT and Details tab.

On Details tab, all status OK and NOT ok will be put on Column H(so there will be the formula). Thanks for helping me in advance and don't forget to download my attach workbook for you to see all possible scenario on SCENARIO tab. Thanks again.


Regards,
Emina002

[NeedForExcel]

Hi!

1. For example and invoice number has PD1 to PD7 is over 90 days. It should flag as OK
2. For example and invoice number has PD1 to PD2 is over 90 days. It should flag as OK

In both conditions you have mentioned PD1 & Over 90 Days. Am I misunderstanding something?

[emina002]

Ok sorry if your confuse..as you see my workbook,not all invoice number can have PD1 TO PD7(As of PD1-As of PD7).
Some invoice number can only have PD1-PD2..PD1-PD3..OR PD4-PD7..etc..if your still confuse,I appologize this is all I can explain I am not fluent in english:-)
You can notice it by reviewing the PIVOT tab on the file.Thanks and Regards.

[emina002]

Up for this..Hope someone could help me with the function and formula..thanks a lot

[emina002]

up to help me solve this

[emina002]

Up this thread. Can someone help me I already attach the workbook

[emina002]

Up for this hope you can help me:-(

[emina002]

Up for this thread..Please help me