Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Return Deduplicated List Range A2:A200

Paste the formula into the first output cell, then fill down to apply it to your range.

Return deduplicated list range A2:A200 with a ready-to-use formula for Excel, Google Sheets, and WPS.

Return deduplicated list range A2:A200.

ExcelGoogle SheetsWPS

=UNIQUE(A:A)

Get unique values from a list with a ready-to-use formula for Excel, Google Sheets, and WPS.

Get unique values from a range with a ready-to-use formula for Excel, Google Sheets, and WPS.

Get unique values a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Get unique values a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Get unique values a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Get unique values a column with a ready-to-use formula for Excel, Google Sheets, and WPS.