Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 2 down vote accepted

There's a possibility to do that, but its a bit complicated. I've prepared an example file for you to play around with: Is there a filter delimiter in Google Spreadsheets?

In the first sheet (DATA) all data is presented. One helper column is added to capture the logic. Here's the logic:

=IF(LEN(B1)>1;INDEX(SPLIT(B1;";"),0,VLOOKUP(FILTERED!$B$1;D:E;2;0));B1)

Based on the value entered in sheet FILTERED' theVLOOKUP` formula will find a number, that will be used for the index function. 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:

=FILTER(DATA!A:B;DATA!C:C=B1)

Just have a look into the example, to see how it works...

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

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
add comment

Your Answer

 
discard

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.