Module data 

Data tab: sort, filter, remove duplicates, text to columns, data validation, outline.

Functions

check_validation

Checks typed input against the validation of a cell. Ok(None) = valid.

filter_values

Distinct display values of a filter column (for the dropdown list).

list_items

List entries of a list validation (literal or from a range) for the cell at. A relative source is written for the rule’s top-left cell and read from at, as in Excel (=$B1:$B3 on A1:A9 lists B5:B7 at A5).

specs