# Best way to have word to show which words uniquely show in list 3 that are not in list 1 and 2, 4, 5 etc.

#### Zelmai

##### New Member
In the attached spreadsheet, in sheets b1, b2, and b3 the first column contains a list of words. In column f of b2 I have formula that compares column a of b2 with column a of b1 and shows all the unique words. This is fine.

However I can't figure out a way to in b3 have column f compare the list of words in column a of b3 with both column a of b1 and b2 and list out words that don't appear in either column a of b1 or column a of b2.

I plan to add lots more sheets, about 65 total and each new sheet will need to see which new words it presents that aren't in column a of any of the previous sheets. So it would be helpful to have the easiest way possible to do this.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### Zelmai

##### New Member
Here is the formula in sheet b2 f2
=FILTER('B2'!A2:D1000,if('B2'!A2:A1000="",FALSE,nOT(ISNUMBER(match('B2'!A2:A1000,'B1'!A2:A1000, 0)) )))

#### Attachments

• Screenshot_20210608-170306.png
140 KB · Views: 2
• Screenshot_20210608-170253.png
217.3 KB · Views: 2
• Screenshot_20210608-170249.png
101.7 KB · Views: 3

Replies
0
Views
102
Replies
12
Views
207
Replies
4
Views
235
Replies
0
Views
49
Replies
31
Views
601

1,141,619
Messages
5,707,445
Members
421,508
Latest member
someinternetuser

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back