Solved

Excel columns - monitor changes

Posted on 2015-02-02
2
81 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 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

930 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now