ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Create 3rd data set off comparison of 2 other sets (https://www.excelbanter.com/excel-worksheet-functions/257526-create-3rd-data-set-off-comparison-2-other-sets.html)

Ron

Create 3rd data set off comparison of 2 other sets
 
Hoping someone out there can help me with this. I have 2 sheets in the same
wb. I need to be able to compare the 2 sets of data in both sheets and have
them combine on a 3rd sheet. For example.
Sheet 1 has the following data in Column A:

abc
defg
hijk

Sheet 2 has the following data in Column A:

abc
hijk
lmn

I need to somehow to have sheet 3 automatically populate with all the items
that show up on both sheet 1 and sheet 2, but only show up once as in the
example below.

abc
defg
higj
lmn

The amount of data in sheets 1 and 2 will change each time the user updates
the workbook, and I need to have sheet 3 populate automatically, so I don't
know if it can be done through formulas, or if a macro is needed.

Any guidance would be appreciated.

Thanks


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com