Finding array of values unique to one table column compared to another table column

**TimRC** · 09-23-2021, 09:49 PM

Hi, I'm new to excel 365 and the dynamic arrays which seem so good.

I have two tables "RawStock" and "Table2"

Both have a SKU column. RawStock[sku] and Table2[sku]

I'd like to find and list only the sku values in column RawStock[sku] that don't appear in column Table2[sku] in a new dynamic array or table.

I've tried using the FILTER, UNIQUE and XLOOKUP functions but now I'm just in a mess.

Could anyone give me some pointers to get me in the right direction?

Thanks so much for your help,
Tim

**Gregb11** · 09-23-2021, 09:56 PM

It's always best to attach a sample file - please read the yellow banner at the top of the page. Absent that, please try this:

=FILTER(RawStock[sku],COUNTIFS(Table2[sku],RawStock[sku])=0)

**TimRC** · 09-23-2021, 10:16 PM

Thanks for the help Greg, That's definitely a solution that works. I'll do a bit more research on the Countifs function now.

Sorry for not positing the example file, I'll do that in the future.

Finding array of values unique to one table column compared to another table column

LinkBack

Thread Tools

Rate This Thread

Display

Finding array of values unique to one table column compared to another table column

Re: Finding array of values unique to one table column compared to another table column

Re: Finding array of values unique to one table column compared to another table column

Thread Information

Users Browsing this Thread

Similar Threads

Need a column of unique values from a table

Counting unique values in a table column

List unique column values from table in new table

Extract unique values in a column from a table

[SOLVED] HELP: I just want to highlight the different/unique values in Column B compared against Co

How Do You Count Unique Cell Entries In A Column With Many Rows Without Using Table Array

Count unique values in one table column if value on same row is not empty

Bookmarks

Bookmarks

Posting Permissions