I need the help of experts.
I have attached the sample and hope to receive help urgently. 30042012.zip
basically, I need to find the ID that is not in D1, but is present in D. so i.e.(ID 12345 in D but not present in D1), then display that ID number.
I am thinking of using MATCH and INDEX, but anything would do as long as it works. Hope that clarifies my needs, thank you and need help badly.
regards,
Melvyn
Bookmarks