公式库

Excel Formula To Generate Unique Values a column

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

快速答案

Generate unique values a column.

统一公式

ExcelGoogle SheetsWPS

=UNIQUE(A:A)

使用说明

将示例区域（如 A2:A）替换为你的实际区域。
保持与示例一致的列顺序。
向下填充以应用到所有行。

需要定制版本？

相关公式

Excel Formula To Get Unique Values From A List

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

Excel Formula To Get Unique Values From A Range

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

Excel Formula To Get Unique Values a column

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

Excel Formula To Get Unique Values a column

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

Excel Formula To Get Unique Values a column

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

Excel Formula To Get Unique Values a column

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