Creating a unique reference to a multiple sequence

Try this...

Data Range

	A	B	C
1	Data	------	Uniques
2	1119		1119
3	1119		1118
4	1119		1114
5	1119		1115
6	1118
7	1118
8	1114
9	1114
10	1115
11	1115
12

This array formula** entered in C2:

=IFERROR(INDEX(A$2:A$11,MATCH(0,COUNTIF(C$1:C1,A$2:A$11),0)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

L1 =if(countif($K$1:K1,$K1)=1,"unique","") and drag down.

After that just filter on unique.