...
| Table settings > Advanced settings > Display data filter | On |
|---|---|
| Column settings > Numbering & totaling > Insert auto number column | On |
Screenshots
Screenshot
| Info |
|---|
For this example, the data shown is |
...
taken from the Monthly temperatures page in the macro. |
...
Example results
Usage:
...
Display rows that contain ja or ma:
...
Display rows that contain 0.:
...
Examples
The following table lists certain search criteria applied against the sample table, filters used, and, the result of the same:
| Requirement | Filter used | Result |
|---|---|---|
| Display temperatures for the months of January, March, and May | ja|ma | |
| Display data with temperatures in the 60s | 60 | |
| Display data with temperatures in the range of 40 to 45 :degrees | 4[0-5] | |
| Display the temperatures for the last quarter of the year | ber |