Formula to create a list of unique values / remove duplicates

It can be done via an array formula, (check this link:http://www.get-digital-help.com/2009...uniquedistinct) but its probably easiest to copy the column to a new sheet then go to the Data ribbon, Data Tools group and use the Remove Duplicates function. Or use a pivot table.

Hi,

Instead of using array formulas, I'd do a very quick Pivot Table and drag the Fruit to the Row box. Then you can copy and paste, using values only the unique values in the fruit column. No formulas needed if you know about Pivot Tables.

But if you do want to use formula, here it is

=IFERROR(INDEX($A$2:$A$10,MATCH(0,INDEX(COUNTIF($E$1:E1,$A$2:$A$10),,),)),"")

	A	B	C	D	E
1	Fruit	Number			UNIQUE FRUITS
2	Apples	2			Apples
3	Pears	4			Pears
4	Oranges	8			Oranges
5	Apples	1			Tomatoes
6	Tomatoes	3
7	Tomatoes	9
8	Pears	3
9	Pears	4
10	Oranges	9