Unique and Filter to select two or more different options from the same list

[Peter Davison]

I have a formula using Unique and Filter below -
UNIQUE(FILTER('Performance Data Master'!$C$3:$D$100000,'Performance Data Master'!$BI$3:$BI$100000=$I$9))
This brings back all stores in England.
What I want to do is filter for more than one option.
I have other selections in Cells I11 (Scotland) and I13 (Wales)
So I added extra filters to the above formula e.g. of one more cell below -
UNIQUE(FILTER('Performance Data Master'!$C$3:$D$100000,('Performance Data Master'!$BI$3:$BI$100000=$I$9)*('Performance Data Master'!$BI$3:$BI$100000=$I$11)))
but this gives a result of Calc?
I am doing something wrong or is it because you cannot filter more than once on the same column (BI)?
Any help would be appreciated
Thanks

 

[kevin9999]

The asterisk * equals and - so you're looking to return a list where column B is both England and Wales

Change the asterisk to a plus sign + which equals or

 

[Peter Davison]

That didn't work
In Cell I10 I have Scotland and in Cell I13 I have England as the selections.
I used the formula with a + instead of a *
UNIQUE(FILTER('Performance Data Master'!$C$3:$D$100000,('Performance Data Master'!$BI$3:$BI$100000=$I$13)+('Performance Data Master'!$BI$3:$BI$100000=$I$10)))
but it just brought back the contents from Cell I13 (England)
Any other thoughts?

 

[kevin9999]

Can you share your actual data using the XL2BB add in, or alternatively share your file via Google Drive, Dropbox or similar file sharing platform?

 

[Peter Davison]

I'm really sorry but my data is client sensitive and links to other files.
Apologies

 

[Peter Davison]

I have found the fault now.
I had it looking at a sheet that was already being filtered.
However you were right it needed the + not *.
So thank you for all your help

 

[awoohaw]

try:

I'm really sorry but my data is client sensitive and links to other files.
Apologies

Although you have figured out the issue, in the future you can always provide sanitized (anonymized) data for the formu to work with.

 

[Peter Davison]

Of course, apologies