Comparing two sheets with two columns each (ID & Date)

**corsi** · 06-23-2016, 01:06 AM

Hi all,

First time poster and have relatively easy one for you excel guns.

I have two sheets in the one spreadsheet, all columns hidden in each sheet but the two that I am wanting to compare with each other. Both sheets have an ID column (made up of letters and numbers) and a date column. The same ID's can be across multiple dates.

What I am wanting to do is compare the two sheets to see what is different about them and present the findings on a third sheet? (excel 2010) I tried the conditional formatting without success as there are some issues with detecting duplicate values in excel 2010 apparently. Not sure of the best way to present this, hoping to get totals for each and see what is missing/additional in each.

Hope this makes sense and thanks for any help you can give me.

**oeldere** · 06-23-2016, 02:51 AM

You can use index/match to find the corresponding data.

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

**crushdrinker06** · 06-23-2016, 08:38 AM

Depending on how you did the formula you could just use an if(match()), example =IF(ISERROR(MATCH(Sheet1!A1,Sheet2!$A:$A,0)),A1,"") would give you any non duplicates from the Sheet1!A column.