Hello, I have something like this:
Sheet1
ID | Date
aaa | 5/5/2015
bbb | 3/4/2015
Sheet2
ID | Date
aaa | 8/5/2015
bbb | 3/4/2015
What I need to do is to make a formula that counts number of all occurrences where Date assigned to ID in Sheet1 is different than Date assigned to the same ID in another sheet.
I spent some hours on this and it seems to be a really big challenge. I assume the formula should contain some VLOOKUP, MATCH, INDEX, OFFSET elements, but nothing works for me.
Could you please help? It is quite urgent task. Your support will be greately appreciated.
Sheet1
ID | Date
aaa | 5/5/2015
bbb | 3/4/2015
Sheet2
ID | Date
aaa | 8/5/2015
bbb | 3/4/2015
What I need to do is to make a formula that counts number of all occurrences where Date assigned to ID in Sheet1 is different than Date assigned to the same ID in another sheet.
I spent some hours on this and it seems to be a really big challenge. I assume the formula should contain some VLOOKUP, MATCH, INDEX, OFFSET elements, but nothing works for me.
Could you please help? It is quite urgent task. Your support will be greately appreciated.