I need a formula to count the number of duplicate values in 2 columns across multiple rows

I'm trying to perform a trend analysis of a process at work and I currently have to do a lot of manual leg work to compile the numbers I need. The part that complicates this for me is that my criteria for what is a defines a duplicate. For my purposes a duplicate is defined as a row where the unique values in columns B and C in one row match the unique value in columns B and C in another row. Please see the table below where the duplicates as I have defined them show up in red font.

	A	B	C	D	E
	Name	Employee ID	Task	Inspector	Pass/Fail
1	Jim	12345	Drilling	Kevin	Pass
2	Jim	12345	Riveting	Tom	Pass
3	Rob	23456	Sealing	Kevin	Pass
4	Jim	12345	Drilling	Tom	Fail
5	Mike	34567	Sealing	Jeff	Pass
6	Mike	34567	Sealing	George	Pass
7	Jim	12345	Drilling	Jeff	Pass
8	Rob	23456	Riveting	Kevin	Pass
9	Mike	34567	Riveting	Kevin	Fail
10	Rob	23456	Wiring	Jeff	Pass

This is merely a fictitious table I put together to give an idea of what an exponentially larger spreadsheet kind of looks like. What I would like to do is either filter out all rows that do not contain duplicates or if that's not possible I would need to get a count of how many duplicates are present and if possible the amount of duplicates of each type (IE Drilling: 10, Sealing: 3, etc). From the researching that I've done it looks like I need to use VBA to do this, but I haven't done anything with VB in over 13 years, so I might as well have zero experience with it. Can anyone provide any incite on how I'd go about doing this?

In my opinion, the best bet in this situation is a formula in another column that can then be used for filtering or any other analysis. If this notion works for you, try the following formula and let me know if it does the trick (obviously, change the ranges to suit the range of your date)

Please Login or Register  to view this content.