Excel "Unique(Filter" function with a Wildcard Variable

[elleb]

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*")))

[Fluff13]

How about

Please Login or Register  to view this content.

[Glenn Kennedy]

For a start, your nomenclature here is wrong:

'Sheet1'Import!

It might need to be

'Sheet1'!

or
'Sheet1Import'

or
'Import'!

So, please read the yellow banner (top) and attach a SMALL sample sheet.