I have multiple columns of data with over 300 rows. I need to show entries
that are unique between two columns. For example if
Column A is Regulation, Column B is Regulated Material, Column C is product.

A B C
1 X 12 TY
2 X 12 CP
3 Y 12 TY
4 Z 15 TY

I want unique entrys only looking at column A and B. In this case there are
3 (rows 1 and 2 for column A and B are the same). I want to be able to put
this into a Pivot table or is there a way to do this with a pivot table? I
don't want to lose any of my other data because I will also need to be able
to sort and compare other columns as well.

Thanks so much!!