• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatin problem

I have a list similar to this. (Have removed other columns with information that is not important for this question)

CA-30003
CA-30003
CA-30003
CA-30003
CA-30004
CA-30004
CA-30004
CA-30004
CA-30005
CA-30005
CA-30005
CA-30005

What I'm trying to figure out is how to use Conditional Formatingto Format the last duplicate of each number in Bold.

I have tried different approaches with No luck.
 
Maybe this rule?

=AND(A1<>"",COUNTIF(A$1:A1,A1)=COUNTIF($A$1:$A$12,A1))
 

Attachments

  • CF Last Duplicate AliGW.xlsx
    8.9 KB · Views: 1
Back
Top