Formula to Highlight Duplicate Numbers located in a single c

John27 · Mar 14th, 2002, 12:52 PM

I have got a list of approx 5,000 employee numbers - and I want to check for duplicates! Is there a quick way to do this besides sorting the data and manually checking for possible duplicates?

Thanks -
John.

Mudface · Mar 14th, 2002, 01:00 PM

If you just have the one column and would like the duplicates removing, you could use the advanced filter.

Make sure you have a column heading, select the cells you want to be filtered, click on Auto-Filter and check the Copy to another location and Unique Records Only boxes, click on a location where you want to the new list to be placed and click OK. HTH.

[ This Message was edited by: Mudface on 2002-03-14 12:01 ]

Al Chara · Mar 14th, 2002, 01:02 PM

Take a look at Chip Pearson's page; it should help.
http://www.cpearson.com/excel/duplicat.htm

kind regards, Al.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 12:52 PM	#1
John27 New Member Join Date: Mar 2002 Posts: 4	I have got a list of approx 5,000 employee numbers - and I want to check for duplicates! Is there a quick way to do this besides sorting the data and manually checking for possible duplicates? Thanks - John.

Mar 14th, 2002, 01:00 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If you just have the one column and would like the duplicates removing, you could use the advanced filter. Make sure you have a column heading, select the cells you want to be filtered, click on Auto-Filter and check the Copy to another location and Unique Records Only boxes, click on a location where you want to the new list to be placed and click OK. HTH. [ This Message was edited by: Mudface on 2002-03-14 12:01 ]

Mar 14th, 2002, 01:02 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Take a look at Chip Pearson's page; it should help. http://www.cpearson.com/excel/duplicat.htm kind regards, Al.