Delete/highlight duplicate row BASED ON 2 COLUMNS

[asiavoices]

Hello all,

I would like Excel to highlight or mark rows that are duplicate BASED ON 2 COLUMNS.

I have seen examples using 1 column and that is not what I want.

For example:

Region Boundary

A 1
A 2
A 3
A 1 <-- duplicate.
B 1
B 5
B 3
C 5
C 1
C 2
C 1 <-- duplicate.
D 2

etc. .....

My criteria is that a region can have the same name but have a different boundary ID.

The ideal scenario is to input a formula on a 3rd column the results of the comparison (0 for no and 1 for yes). I'll then do a filter based on 1s and delete those rows.

Any ideas?

Thanks,

Christopher

 

[xlhelp]

If you go

http://www.cpearson.com,

Chip has a sub-routine written just for this purpose; as such, no need to re-invent the wheel.

HTH

Indu