Excel 2007 : Compare and show only the different value cells as result?

Dear Friends,

I have worksheet with multiple cells per set that to be checked with another set of cells as in the attached worksheet and show the different value cells as a result. What is the code to solve the problem?

The First Set has the Master Data. If second set ("To Check") doesn't have the data which is in the Master Data then it should show the missed data the in the Result.

Thanks in advance.

formula provided by NBVC works as long as column H is filled in.
If you want both columns filled in automatically, then you need to first create the list in column H.

See attached file. I have created a number of helper columns [M thru' P], to show the process and logic. You can leave it as is and use it or try to combine the formulas in one cell.

I am sure someone will come up with a cute little formula that will do the trick.

Until then, use the sample provided here.
modytrane

Originally Posted by modytrane

formula provided by NBVC works as long as column H is filled in.
If you want both columns filled in automatically, then you need to first create the list in column H.

See attached file. I have created a number of helper columns [M thru' P], to show the process and logic. You can leave it as is and use it or try to combine the formulas in one cell.

I am sure someone will come up with a cute little formula that will do the trick.

Until then, use the sample provided here.
modytrane

Thanks for your help. I need a macro to do this job. Any help please?

Originally Posted by JBeaucaire

Try this one, thought I'd uploaded it yesterday, my apology for the delay.

Please Login or Register  to view this content.

Thanks for the help.