Getting unique values in Excel by using formulas only

[koskesh]

Hi, I have a workbook with 4 columns.
I need a formula in Column F:1 for the unique values of the first column. I have duplicate values in the column (4 digit numbers).

The output should look like this

1101;1102;1103..

The table is dynamic, I add lines to the column A.

Thank you

 

[Deepak]

Pls check this.

 

[Ramesh Deo]

Hi Koskesh,

If you want to extract unique value if cell F1 for column A then try below formula-
=INDEX($A$2:$A$15,MATCH(0,COUNTIF($A$1:A1,$A$2:$A$15),0))
Use CTRL +Shift+Enter and copy down.
if this help you otherwise upload sample file.

 

[pecoflyer]

Do you need unique values or distinct values?

 

[Deepak]

Do you need unique values or distinct values?

Is there any difference in these two ???

 

[pecoflyer]

Absolutely. Unique values only appear once in a list. Distinct values can appear once or many times.