Find duplicate rows based on 2 columns of different data:

I need to find the rows that have duplicate Year and Parcel ID. I have manually typed in YES or NO in Column E (Duplicates) to show the match I am trying to code into Column E (Duplicates).

Rows 2 and 3 are duplicates, and row 4 is not.
Rows 5 and 6 are not duplicates.
Rows 7 and 8 are duplicates, and rows 9 and 10 are duplicates.
Rows 11 is not.
Rows 12 and 13 are not

I need to replace Column E (Duplicates with a formula that will do this. There are over 6000 rows that I need to find the duplicate Year and Parcel ID for.

A B C D E
1 Client F Client L Year Parcel ID Duplicate
2 Jack Sias 2008 07 2700 0169 032 4 YES
3 Jack Sias 2008 07 2700 0169 032 4 YES
4 Jack Sias 2009 07 2700 0169 032 4 NO
5 Henry Kim 2009 075 0 01 034N NO
6 Henry Kim 2010 075 0 01 034N NO
7 Vishal Jatia 2008 09F 0901 0048 075 1 YES
8 Vishal Jatia 2008 09F 0901 0048 075 1 YES
9 Jack Sias 2008 09F 0903 0050 049 9 YES
10 Jack Sias 2008 09F 0903 0050 049 9 YES
11 Jack Sias 2009 09F 0903 0050 049 9 NO
12 Neil Patel 2008 09F 1503 0063 170 0 NO
13 Neil Patel 2009 09F 1503 0063 170 0 NO


Column E (Duplicates) can be 1 or 0, or color, it does not have to be YES and NO, but I need to be able to sort on the value. I will use 3 level sort (Duplicates, Parcel ID, Year) once I can find the duplicates.

I have attached a jpg since I was not able to keep the columns lined up when I previewed this posting.

Thank you for any help anyone can provide,
Richard

zbor,
Awesome! I wanted to thank you for taking time and posting a suggestion!

It truly amazes me the power of the Internet and sharing information!

I spent 6 hours trying find solution last night! And ended posting on 2 forums.

Your solution I have decided to use, and once I figured out i needed to adjust the range to replace column E with the YES and NO, it worked perfect! I put this in Column E

=IF(SUMPRODUCT(--($B$2:$B$13=B3),--($C$2:$C$13=C3),--($D$2:$D$13=D3))>1,"YES","NO")

This replaces the YES and NO I manually typed in column E with the correct value!

Thanks!,
Richard