Please help me

[Kristine]

I hope this is okay.

I am trying to get 1 filter to search 3 or more columns.

The spreadsheet is Names and addresses of places and the information I want sorted is the companies who service those locations

Example:
ClientA AddressA ServiceProviderA
ClientB AddressB ServiceProviderA ServiceProviderB
ClientC AddressC ServiceProviderB

I want to be able to filter Column C with both the information in column C and Column D.

So in the example I would want both ClientB & ClientC's information to show when searching for "ServiceProviderB"

Is there a way to do this? Some rows would only have 1 service provider, and some could have 15

Thanks in advance

 

[Hui]

Kristine

Firstly, Welcome to the Chandoo.org Forums

Please see attached

You can use the Filter of the Contains field and sort by largest to Smallest

 

[Kristine]

Thank you for your help, is the only way to do this is to enter every service provider for a particular location into one cell?

I am sorry, I have a very basic knowledge of excel