Do you have a Workbook?
I do but i cant share the data since its conidential. I can share a snapshot of the excel and randomise the data.Will that help
here is a screenshot.
What i would like to do is display PN1 to PN4. If ca,CAP,EX,FA are all zeroes for 2018/2019 and 2019/2020 i will exclude them. but if there has been a change in goal, DTC or ca,CAP,EX,FA as compared to the refernce table i will include them.As seen in PN4 all are zeroes but we have them included since there was a change from reference table.