Solved

Excel columns - monitor changes

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
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!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

803 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