Copying over cell info to a master sheet

[oboegal21]

Hello,

I am wondering if there is a formula that would do the following:

I have Worksheet A, Worksheet B, And Worksheet C

Worksheet A and Worksheet B both have a column that has a Person's Name

I would like a formula in Worksheet C to bring over the names in Worksheet B and I want it to bring over the names in Worksheet A only if that name is not in Worksheet B. If the name is duplicated in Worksheet B then I do not want the name brought over.

Worksheet C is being created as an autofill master which is where this formula will be housed.

Thank you for your assistance.

[Jdevil]

That might not work for you but perhaps...

Bring the data from both Worksheets A and B in Worksheet C. That will obviously include your duplicates.

Then, select the data, and go in Data -> Unique Records only (the third option in data tools, not 100% sure it's called like that in english). That will delete any duplicate.

[Lemice]

Hello oboegal21,

You can do so by utilizing either Array Formula (will slow down performance on large amount of data) or by using helper column with COUNTIF or a simple ISERROR and MATCH combo to check if a name in Sheet A is already in Sheet B

If you can attach a small sample workbook with mocked-up data, that'll be much easier for others to help you too.