find all same numbers in a column without dropdown listing

[ShoDan]

Trying to find all alike numbers in a column of about 5000. Data is sorted
by number already but the list it to long to look through. Filtering the
data only brings up another long list to have to go through. Is there a
formula that will find them and highlight them? There could be numerous
different ones.
Example
001-3456
001-3456
001-7890
001-7890
002-9876
002-9876
002-9787

Find all alike

Thanks

 

[Dave Peterson]

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

 

[Gaurav]

I think you can use countif in conditional formatting.

If your list is in column A.

Select A1 and set the conditional format

Formula Is:
=COUNTIF($A$1:$A$5000,A1)>1 and pick the color you want.

Copy A1 and pastespecial / formats from A1 thru A5000.

 

[CLR]

Check out Jim Cone's fine commercial Add-in called "XLCompanion".........it's
available at:

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3