2

I've got a list of customer feedback from a company's website. We'd like to filter the data by store, so we can shout out the staff members or stores that are doing particularly well, and give them extra credit. Obviously customers leaving feedback may mention the store location, the member of staff that they spoke to, or any other factor that they valued, so ideally I'd like the company to be able to add to a list of keywords that they can use for the filter.

The sheet that I've attached below is some test data that I've put together, in case the above isn't clear.

The closest I've got is using =FILTER(All!A1:A10,ISNUMBER("Cardiff",All!A1:A10),"No Results") - although I know this would have to be edited in detail every time another filter term needed to be added. Also, for some reason, I'm returning the error "FILTER has mismatched range sizes. Expected row count: 10, column count: 1. Actual row count: 1, column count: 1." when I try it.

Would really appreciate any help anyone can give me - I'm completely confused, and making no progress!

https://docs.google.com/spreadsheets/d/1em4ix965Ej6ipevgfOfcfqtG-nOgT_9q5c4vdBHRyig/edit?usp=sharing

1
  • Consider showing your hand-entered expected results in the sample spreadsheet. Clearly identify where the expected results are. Oct 13, 2021 at 9:01

1 Answer 1

0

To find values in Master!A1:A that match the text string in cell C1 or the text string in cell C2, use this:

=iferror( filter( Master!A1:A, iferror(search(C1, Master!A1:A)) + iferror(search(C2, Master!A1:A)) ), "(no results)" )

2
  • That's perfect! Thanks so much. Annoying that the formula has to be updated each time I add another value (staff member arriving or similar) but definitely not the end of the world, and a lot better than the current method of doing it by hand!
    – Pod
    Oct 13, 2021 at 9:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.