Solved

Excel columns - monitor changes

Posted on 2015-02-02
2
93 Views
Last Modified: 2015-02-02
Trying to flag changes where the value under JOB column is the same, but value under PAT column is different. What is the Excel 2010 formula to achieve this? **See attachment
*If values in PAT are the same and job number is the same, I’d like a N. Where the values under JOB are the same and the values in PAT different, I’d like a Y.

Thanks for your tremendous assistance.
Dupls.xlsx
0
Comment
Question by:saved4use
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 40585258
Enter this formula in C2 and copy down

=IF(A2=A3,IF(B2<>B3,"Y","N"),IF(A2=A1,IF(B2<>B1,"Y","N"),""))
0
 

Author Closing Comment

by:saved4use
ID: 40585269
Excellent solution!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question