Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to build a list of servers in a Google Spreadsheet. Each server has multiple services, and I would like to be able to select a single service and see all the servers providing that service.

The problem I'm facing is the multiple services part. There's too many to provide a column for each service. Is there any sort of delimiter I can specify in the filter?

enter image description here

Or is there maybe a better way I can do this?

share|improve this question
up vote 2 down vote accepted

There's a possibility to do that, but its a bit complicated.





In the first sheet (DATA) all data is presented. One helper column is added to capture the logic. Based on the value entered in sheet FILTERED the VLOOKUP formula will find a number, that will be used for the index function ($D$2:$E$4). That will show only a specific column, given by the split function. In the FILTERED sheet the result of the DATA sheet will be in filtered by the entered value in FILTERED.


enter image description here

enter image description here


I've prepared an example file for you: Is there a filter delimiter in Google Spreadsheets?

share|improve this answer
Nice solution. Yes, complicated but very nice. – Weehooey Feb 9 '13 at 11:44

There are no filter delimiters or other tools which will achieve what you are looking for... that I know of.

One approach to the problem would be to make it a list of services rather than a list of servers.

For example, your data might look like:

server1     dns;dhcp;dc
server2     dc
server3     dns;dhcp;dc

the new data would look like:

dns      server1
dhcp     server1 
dc       server1 
dc       server2
dns      server3 
dhcp     server3 
dc       server3

Of course, this may mess with your other plans for this list.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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