I've an urgent need and for the life of me can't figure it out, although I'm pretty sure it's very straight forward.
I have different versions of a file which are issued monthly. Each version has a constant, which is an ID No., but the date may change and it's the change in dates that I need to be able to identify easily and if formatting can be used to highlight it, even better.
I've attached a simple example and hope that somebody can give me the formula to solve this query.
So, I have a list of ID's with an original date and then the same list of ID's where two of the original dates have changed. I'd like to be able to write a formula that can do this for me automatically.
For your info a file listing ID's and dates is issued to a vendor monthly and they return the same file, but may have updated some of the dates. I need to be able to compare the ID's and if the date has changed highlight this.
I look forward to your help.