Question

Which command is used to identify the unique values of a column?

Answer 1

Hope it helps you.....

Answer 2

Answer:

=IF(COUNTIF($A$3:$A$20, $A2)=1, "Unique", "") is used to identify the unique values of a column

Explanation:

It is possible in the “excel” to select and identify unique values of a column. To achieve that do as directed below:

If is a conditional statement that verifies the given statement is true, here it checks column A3 to A20 with the value in cell A2, if the count of the given condition is 1 then print  unique, otherwise it prints not unique. You can also highlight the duplicate rows or unique rows.