How do I use the Excel Formula To Return Unique Entries Range A2:A200 formula?

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

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

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

Return unique entries 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.