Hello,
I have 4 columns 1st contains numbers, the 2nd contains dates
The 3rd and 4th columns contains numbers and dates as well.
I would like to compare the sets of two columns to one another.
For example.
Column 1 row 1 contains 1234
Column 2 row 1 contains 1-11-11
Column 3 row 25 contains 1234
Column 4 row 25 contains 2-15-99
So the formula would find the matches between column 1 and 3 and then tell the user if there is a differnce in the dates in columns 2 and 4. In this case it would place YES in a new column (I guess column 5)
Can this be done or do I need to look into VBA?
Thanks,
Bookmarks