Matching ID numbers

[arundberg]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

What I am trying to do is search through my workbook to make sure that I don't have any studies repeated. What I am doing is looking up government research studies and putting that information into a workbook. One of my fields is an identification number. Is there anyway to have excel find any matches in the identification column?

Thanks
Aaron

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

What I am trying to do is search through my workbook to make sure that I
don't have any studies repeated. What I am doing is looking up government
research studies and putting that information into a workbook. One of my
fields is an identification number. Is there anyway to have excel find any
matches in the identification column?

One way:

Select the column (say, column A, with cell A1 active). Choose
Format/Conditional Formatting... Set the dropdown and input box to read

CF1: Formula is "=COUNTIF(A:A,A1) > 1"
Format1: <patterns>/<color>

 

[arundberg]

Thanks