This is the printable version of the document
http://public.sheet.zoho.com/public/popx/HLBNZxbMEHM3n1MTcYxRsvrB6erdewTN
.
remove_non_matches
Sheet1
This spreadsheet removes all strings that do not match a specified pattern. In this example, the pattern is 'X*'.
This spreadsheet was generated by Jocelyn Paine, using Excelsior. There's an explanation of how it works at http://www.j-paine.org/excelsior/repository/remove_non_matches/index.html .
elements to search
the index
matching elements
Not X
-1
X
-1
Not X
-1
Not X
-1
X2
-1
Not X
-1
Not X
-1
Not X
-1
-1
X4
-1
X5
-1
Not X
-1
Not X
-1