Excel UNIQUE Function – Google Sheets Alternative | ComTools

Learn Excel UNIQUE: what it does, Google Sheets support (Supported), alternatives (—), and convert formulas online.

What is Excel UNIQUE?

Returns unique values.

Google Sheets compatibility

On Google Sheets, UNIQUE is marked as Supported.

Convert with ComTools

Paste a formula that uses UNIQUE into /excel-formula-converter, choose Google Sheets or Excel as the target, and get support status plus suggested rewrites.

FAQ

QDoes Google Sheets support UNIQUE?

Status: Supported. Check the suggestion text on this page.

QCan ComTools rewrite my formula automatically?

Simple renames (e.g. TEXTAFTER→REGEXEXTRACT, TEXTSPLIT→SPLIT) and simple LET expansions are attempted; complex formulas get guidance.