Excel Formula for Unique Values Not Apart of Exclusion List-CodePudding

Good day all,

Using Excel formulas, how do I solve for uniques within array that aren't apart of uniques from another array?

I've tried.

=UNIQUE(B:B&"<>header",FALSE,TRUE)

=UNIQUE(B:B,FALSE,TRUE)&"<>header"

=UNIQUE(B:B,FALSE,TRUE)-"header"

=UNIQUE(B:B,FALSE,TRUE)-{"header"}

{=UNIQUE(B:B,FALSE,TRUE)-{"header"}}

{=UNIQUE(B:B,FALSE,TRUE)}-{"header"}

{=UNIQUE(B:B,FALSE,TRUE)&"<>header"}

=UNIQUE(B:B,FALSE,TRUE)-UNIQUE("header")

In this example I've only excluded 1 header, however my headers will be constantly moving so it is important I can dynamically add and subtract unique items to remove from entire column.

Edit: Giving more information below

I've continued research and came across this article however it doesnt fit my needs.

CodePudding user response：

=FILTER(list2,COUNTIF(exclusion,list2)=0)

Or without list 2 helper: =UNIQUE(FILTER(listist1,COUNTIF(exclusion,list1)=0))