| Table Instructions |
|---|
| Typing text into a search box will filter records based on what you have typed: |
| Type | Description | Example |
|---|---|---|
| text | Any text entered in the filter will match text found within the column. | abc (finds "abc", "abcd", "abcde", etc) |
! |
Filter the column with content that does not match the query. | !fe (hide rows with "female" in that column, but shows rows with "male") |
" ' = |
Filter by exact match by adding a quote / apostrophe / equal sign to the beginning or end of the query. | abc" or abc= (exactly match "abc") |
* |
Wildcard for zero or more non-space characters. | B*k (matches "Black" and "Book") |
< <= >= > |
Match letters or numbers less than or greater than or equal to the filtered query. | >= 10 (find values greater than or equal to 10) |
AND |
Filter the column for content that contains text from either side of the AND (all caps). | box AND bat (matches a column cell that contains both "box" and "bat") |
OR |
Filter the column for content that contains text from either side of the OR (all caps). | box OR bat (matches a column cell with either "box" or "bat") |
... |
Find a range of values. Make sure there is a space before and after the ' ... '. | 10 ... 30 (match values between 10 and 30) |
Forgot Password |
