Comparing two columns of text data

[RJB]

I'm working with copies of someone else's SAP files.

Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".

After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.

Notifications have distinct numbers, as do work orders.

So you may have:

NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to three
0001 | 2985 | Lubed
0001 | 2985 | Closed with comments


A vast majority of the time, ONE notification will lead to ONE AND
ONLY ONE work order. There are SOME notifications that lead to two (or
more) work orders.

I need to find a way to highlight those that lead to two or more.

The best I could come up with was:
- Sort
- Do a lookup (which would return the FIRST work order associated with
that)
- Have a column, IF LOOKUP = WORK ORDER, 0, 1
- Sort on that 1

But that seems clunky and inaccurate.

Thanks

 

[Jacob Skaria]

Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)>1

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.

 

[RJB]

Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)>1

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.

 

[RJB]

Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)>1

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.

Not working....