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?Or is there maybe a better way I can do this?
Is there a filter delimiter in Google Spreadsheets?
google spreadsheets
There's a possibility to do that, but its a bit complicated. Formula=IF(LEN(B2)>1,INDEX(SPLIT(B2,;),0,VLOOKUP(FILTERED!$B$1,$D$2:$E$4,2,0)),B2)=FILTER(DATA!A:B,DATA!C:C=B1)ExplainedIn 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.ScreenshotdatafilteredExampleI've prepared an example file for you: Is there a filter delimiter in Google Spreadsheets?