Find Duplicate items in a sheet

[minrush]

How can I find duplicate items in a sheet.. Example..

I have a sheet that has a series of numbers

1112
1114
1115
1119
2223
3434
2222
2222
1112

I need to sort and delete 1112 because it has been entered twice

also with alphabets too..

 

[mikerickson]

Use Advanced Filter to copy the list to a different location (unique entries only). Delete the original list and copy back.

 

[Lewiy]

Try this:

Book4
	A	B	C	D	E	F
1	1112	1
2	1114	1
3	1115	1
4	1119	1
5	2223	1
6	3434	1
7	2222	1
8	2222	2
9	1112	2
10
11
12
13
14
15
16
17
18
Sheet2

You can then use an autofilter on column B for values greater than 1 and delete them.