find all same numbers in a column without dropdown listing
 

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

find all same numbers in a column without dropdown listing
 

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

ShoDan wrote:

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

find all same numbers in a column without dropdown listing
 

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.

"ShoDan" wrote in message
...
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

find all same numbers in a column without dropdown listing
 

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



"ShoDan" wrote:

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