Sieve
The Sieve() function allows the masking of specified cell values in a block of cells.
Related functions: Colouring
Syntax
Sieve ()
| Value | The range of cell values to which to apply a sieve |
| Sieve | The sieve markers |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
Example – Using Sieve to mask cell values
The Sieve range is applied to the input range. Wherever the a cell in the sieve range is not blank, the equivalently located cell in the input range is masked.
| Input Range | Sieve | Apply the Sieve | ||||||
| 11 | 22 | 33 | x | x | x | =Sieve($A$2:$C$4,E2:G4) | ||
| 44 | 55 | 66 | x | x | x | |||
| 77 | 88 | 99 | x | x | x | |||
| A | B | C | =Sieve($A$2:$C$4,E6:G8) | |||||
| D | E | |||||||
| F | G | H | ||||||
| =Sieve($A$2:$C$4,E10:G12) | ||||||||
| 100 | ||||||||
| 200 | ||||||||
| =Sieve($A$2:$C$4,E14:G16) | ||||||||
| Input Range | Sieve | Result | ||||||||
| 11 | 22 | 33 | x | x | x | |||||
| 44 | 55 | 66 | x | x | x | |||||
| 77 | 88 | 99 | x | x | x | |||||
| A | B | C | ||||||||
| D | E | 55 | ||||||||
| F | G | H | ||||||||
| 11 | 22 | 33 | ||||||||
| 100 | 44 | 66 | ||||||||
| 200 | 77 | 88 | ||||||||
| 11 | 22 | 33 | ||||||||
| 44 | 55 | 66 | ||||||||
| 77 | 88 | 99 | ||||||||