| Info | ||
|---|---|---|
| ||
Datameer X provides a feature to filter data on a worksheet by specified criteria. Additional filters can be added as well as regular expressions or formulas can be used. |
...
| Info | ||
|---|---|---|
| ||
When creating a filtered sheet that displays no data, Datameer X informs you that the empty sheet is displayed on the current sample data. Running the workbook again creates a new sampling for the sheets that take into account the calculation of the filtered sheet. |
...
| Info | ||
|---|---|---|
| ||
Advanced filter formulas are similar to those used in a workbook's formula bar though without column name completion and less error handling. You can create a formula that combines multiple conditions using multiple referenced columns or use nests functions and constants. Text-based expressions must return a Boolean value and are required to reference columns in the current sheet. When the expression that is applied to the current record returns 'false', the record is dropped, otherwise it remains. |
| Tip | ||
|---|---|---|
| ||
Datameer X recommends developing and testing your advanced filter formulas in a separate copied worksheet before applying to your actual data. |
...