Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel columns - monitor changes

Posted on 2015-02-02
2
Medium Priority
?
110 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
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

607 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