Hi all,

I am trying to use the excel Unique(Filter function to return a unique list of values but, the variable can alter slightly in name. I have tried the below for a wildcard search but it is coming up with a #calc error.

Can you use the formula without looking for a specific text?

=UNIQUE(FILTER('Sheet1'!T:T,('Sheet1'Import!A:A="*"&Test&"*")))
=UNIQUE(FILTER('Sheet1'!T:T,('Sheet1'Import!A:A="*Test*")))