help tying two values to locate duplicates
Hi  I have a sheet with PARF #s and Position #s  I would like to flag any row that has the same PARF# and same Pos# in the column to locate a duplicate employee 
ie., PARF# Position # Flag
12345 789
9998 789
12345 789 X (duplicate)
I've tired the Count IF with And but it does not work  I feel like it should be simple... any help would be appreciated.
Best Answer

Instead of COUNTIF with AND, use COUNTIFS (this allows you to look at multiple pieces of logic).
=COUNTIFS([PARF#]:[PARF#], [PARF#]@row, [Position#]:[Position#], [Position#]@row)
Then add an IF so that if the value of the COUNTIFS is greater than 1 it returns X.
=IF(COUNTIFS([PARF#]:[PARF#], [PARF#]@row, [Position#]:[Position#], [Position#]@row) > 1, "X")
This will flag both duplicate rows, is that acceptable?
Answers

Instead of COUNTIF with AND, use COUNTIFS (this allows you to look at multiple pieces of logic).
=COUNTIFS([PARF#]:[PARF#], [PARF#]@row, [Position#]:[Position#], [Position#]@row)
Then add an IF so that if the value of the COUNTIFS is greater than 1 it returns X.
=IF(COUNTIFS([PARF#]:[PARF#], [PARF#]@row, [Position#]:[Position#], [Position#]@row) > 1, "X")
This will flag both duplicate rows, is that acceptable?

YOU ARE MY HERO!!!! WORKED LIKE A CHARM  :)

Wonderful! Thanks for letting me know.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!