Finding dates between 2 worksheets that aren't equal

[mastro78]

I'm fairly new to Excel and have been tasked with comparing to huge data sets (same workbook, Sheet1 & Sheet2) that have the same Unique Identifier but can contain varying dates. Sheet1 Column A contains the same set of Project#s as Sheet2 Column A. And Columns B through HH contain corresponding dates for each Project#. Each column has a heading so row 1 is only headings. What I want is if Sheet1!A:A matches Sheet2!A:A but any of the other columns have different dates than what are in Sheet1 that they are highlighted (or pointed out in some way) in Sheet2. This seems a bit beyond a typical VLookup, Match, or If function for I have tried multiple approaches. PLEASE assist! Thank you in advance!

 

[Akashwani]

Hi,
Welcome to MrExcel.

Question.
Will the Unique Identifier in A2 on sheet1 be the same in A2 on Sheet2.
If so, is this what you imagine the result to be?....

Excel Workbook
	A	B	C	D	E
1	ID	Date	Date	Date	Helper
2	123	11/01/2011	12/01/2011	13/01/2011	121665
3	124	23/01/2011	24/01/2011	25/01/2011	121701
4	125	11/02/2011	12/02/2011	13/02/2011	121758
5	126	23/02/2011	24/02/2011	25/02/2011	121794
6	127	11/03/2011	12/03/2011	13/03/2011	121842
7	128	23/03/2011	24/03/2011	25/03/2011	121878
8	129	11/04/2011	12/04/2011	13/04/2011	121935
9	130	23/04/2011	24/04/2011	25/04/2011	121971
Sheet1

Excel Workbook
	A	B	C	D	E	F
1	ID	Date	Date	Date	Helper	Match
2	123	11/01/2011	12/01/2011	13/01/2011	121665	MATCH
3	124	23/01/2011	24/01/2011	26/01/2011	121702	1
4	125	11/02/2011	12/02/2011	13/02/2011	121758	MATCH
5	126	22/02/2011	24/02/2011	25/02/2011	121793	1
6	127	11/03/2011	12/03/2011	13/03/2011	121842	MATCH
7	128	23/03/2011	24/03/2011	25/03/2011	121878	MATCH
8	129	11/04/2011	12/04/2011	15/04/2011	121937	1
9	130	23/04/2011	24/04/2011	25/04/2011	121971	MATCH
Sheet2

You will see that I have used a Helper column on sheet1 to sum the dates. I have added 2 helper columns on sheet2, one to sum the dates and one to identify if the values in the helper column are the same or not. I have then used Conditional Formatting to highlight the rows were 1 appears in the MATCH column.

If your Unique Identifiers are not in the same row then I'm not sure how to solve this for you, sorry.

Good luck

Ak