Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel columns - monitor changes

Posted on 2015-02-02
2
Medium Priority
?
108 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

564 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