• 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.

Identify a change in one column to another

S

Shelli Stenerson

New Member
Hi!
I am fairly new with Excel and new on the Chandoo Forums.

I have a spreadsheet (see attached) that I would like a simple way to do conditional formatting, or better yet, only filter/return the data when there is a change in Column B (Dept), when Column A (MRN) is still the same.

In other words, I would like to only see patients (MRN) that have been seen in different departments (Dept).

Thanks in advance for any help one can provide.
 
Last edited:
Welcome to Chandoo.org forums.

In cell J2 insert below formula and copy down and then filter cells with TRUE result:
=COUNTIF($A$2:$A$1252,A2)<>COUNTIFS($A$2:$A$1252,A2,$D$2:$D$1252,D2)
 
Shrivallabha - Thank you so much. I had tried different variations of the countif, but not in the manner you provided.
Your formula works perfect, and I am so appreciative of your help.
Thank you again and take care.
 
You must log in or register to reply here.
Back
Top