Duplicate Checking

This will not solve your problem, but it might make it easier:

If your data look like this:

PHP Code: 

           A
 1) Amity Church
 2) Churchof Christ
 3) NM State Highway
 4) Spot Free Power Wash
 5) CIT Apartment Complex
 6) Housing Agency
 7) Pinon Pizza Edge
 8) Peabody TC
 9) Business Affairs
10) O B Trailer Service
11) Red Mesa Express
12) Jimmy's Pizza 


By using Conditional Formatting you can Highlight those companies that have a unique identifier, such as the term Cisco or in the above case the word Pizza.

We will use cell B1 as the search string.
So in B1 enter the word Pizza

Then using Conditional Formatting, this is for 2007:

1) Select your range of cells: A1:A12

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter the formula: =IF(FIND(LOWER($B$1),LOWER($A1),1),TRUE,FALSE)

EDIT ADDED: here is a shorter form: =FIND(LOWER($B$1),LOWER($A1),1)

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OK

The two cells in column A that contain the word Pizza, row 7 & 12, should light up.

Now you can see where all your Cisco's or Pizzas' are.