Need Macro which compares the values between the rows in excel

**Karthik Sen** · 04-14-2012, 03:57 AM

Hi All,

I need a macro which compares the values between the rows in excel and produce the output which contains only the different values. Please refer the excel sheet for more details.

**Marcol** · 04-14-2012, 04:39 AM

This can be done without a macro.

With Sheet2
In A2

Please Login or Register  to view this content.

Drag/Fill Down

In B2

Please Login or Register  to view this content.

Drag Across to Column G, then Down as required.

**slxia1** · 04-14-2012, 06:07 AM

Hi Marcol,

I dnt really see what your solution is doing,
I thought only the difference will be displayed?
What exactly are you comparing?

**Marcol** · 04-14-2012, 06:48 AM

@ slxia1

I thought only the difference will be displayed?

That is what I think it does.

It takes the IDs from Sheet1 into Sheet2, then compares the differences in the rows in Sheet1 where there are duplicate IDs.
If there are differences, they are returned for each row, if not the cell is blank.