Highlight 18 Digit cells in Column A that occur in "triplicate" (not using Cond/Form)

[mlewand420]

I have searched everywhere for my specific issue and get close but can't quite find a reasonable solution. My goal is to highlight in (RED=3) all occurrences of an 18 digit number appearing 3 or more times in Column A2:LastEntry.

Here's the catch - I have almost 200,000 records and conditional formatting cannot take the "volume" as it is too slow and locks up the PC.

The following code works to a certain extent. It will do a very quick highlight of all "Duplicates ONLY" in RED but I cannot get it modified to Just highlight "Triplicates ONLY".

Please Login or Register  to view this content.

SAMPLE DATA:

100394600000004266
100394600000004266
100394600000004266
100394600000004316
100394600000004316
100394600000004324
100394600000004324
100394600000004837
100394600000004837
100394600000004837
100394600000006352
100394600000008218
100394600000008523
100394600000008523
100394600000009406


A VBA Code that will works for me would only FILL color "100394600000004266" & "100394600000004837" RED.

Id this possible outside of Conditional Formatting? Thank You

[Leith Ross]

Hello mlewand420,

This macro will highlight triplicate values in red font in column "A". The values do not have have to do not have to be in sequential rows. This macro did 200000 rows in about 3.75 seconds on my machine. Your time may vary.

Please Login or Register  to view this content.

[mlewand420]

Leith, your code works exactly like I imagined. Thank You!