Unique cells in column

[jakobt]

I have a column with a lot of data.

I select the column/range.

How can I generate a list starting in cell c1 with all unique items from the column.

(Preferably in alphabet order)

 

[KennyGreens]

Hi, would a PivotTable not work for this?

 

[jakobt]

It is not a bad surgestion...however I would prefer a piece of VBA code
for the learning experience also..

 

[James006]

Hi,

With your data located in range A2.A8 ...

you could have in cell B2 the following Array Formula:

=IFERROR(INDEX($A$2:$A$8,MATCH(0,COUNTIF($A$2:$A$8,"<"&$A$2:$A$8)-SUM(COUNTIF($A$2:$A$8,B$1:B1)),0)),"")

Hope this will help