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

Very urgen, pls help: Find same data in two colums

M

mediatx

Member
sorry for the dramatic intro, but I am finalizing my H1 report and found some errors that I need to validate. To find the errors i need to validate existance of a specific number.


To find it, I have two colums (A1 = Tool1Data | B1 = Tool2Data)

How can I find out what data in "Tool1Data" are also available in "Tool2Data".


In dummy words:


1) check which entries from Tool1Data arent available in Tool2Data and make them red

2) check which entries from Tool1Data are also available in Tool2Data and make them green


Please note:

Tool1Data contains less data (filtered, cleaned,....) than Tool2Data.

However, I know that Tool1Data has items that arent in Tool2Data colum - its exactly these items I need to find / identify.


Please, anyone an help?
 
Highlight both the rows & In conditional formatting, select duplicate values & select the color u want to see when there are duplicate values
 
I guess the above message is written by u in acute panic condition,

whatever is not highlighted by duplicate conditional formatting are the unique one. ha ha ha ......simple logic.....
 
"i like" - yes, was absolutely in panic... you might know that if you ever had to do a H1 Report within 2 days time (from scratch!)
 
You must log in or register to reply here.
Back
Top