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
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!