Highlighting Duplicate Entries in the same Worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darran - 06 Jul 2006 14:05 GMT

Hi all,

I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
need to highlight which ones appear in both lists.

Should be striaght forward but I cant seem to get it to work. I guess it
should be some for of conditional Formatting.

Thanks in advance

Darran

Reply to this Message

Bob Phillips - 06 Jul 2006 14:14 GMT

CF with a formula of say

=COUNTIF(A:A,A1)>1

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Darran

Reply to this Message

Traveller - 06 Jul 2006 16:17 GMT

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Darran

Reply to this Message