Filter Functions

SheetX provides filter functions that help you identify, extract, and organize data based on specific conditions.

Functions Overview

Function	Description
SX_DUPLICATES	Identifies duplicate values within a range.

SX_DUPLICATES

The SX_DUPLICATES function identifies duplicate values within a range, making it easier to detect repeated records and maintain clean, consistent datasets.

Syntax

=SX_DUPLICATES(range, [columns], [mode], [case_sensitive], [remove_spaces], [trim_spaces], [normalize_spaces], [if_no_duplicate_found])

Arguments

Argument	Description
range	The values to search for duplicates.
columns	The column(s) of the range to check for duplicates. If omitted, the entire columns of the range are used for the duplicate search. Column(s) are specified in a string separted by commas.
mode	How duplicates result should be presented. duplicates - Shows the duplicates result. count - The number of duplicates. group - Partitions duplicates into groups by assigning a unique number. Default: duplicates
case_sensitive	Whether the comparision should be case-sensitive. Default: True
remove_spaces	Whether to remove all spaces from the values. Default: False
trim_spaces	Whether to remove leading and trailing spaces. Default: True
normalize_spaces	Whether to replace consecutive whitespace with a single space. Default: True
if_no_duplicate_found	The value to return when no duplicates are found. If omitted, the function throws an error when no duplicate is found. Default: Throws an error.

Use Cases

• Identify repeated values in datasets before analysis.
• Detect duplicate product records in stock lists.
• Find repeated email addresses in mailing lists.
• Detect repeated transaction identifiers or reference numbers.