I have a file with more than 2000 rows i want to reconcile as follows
A B
1 100
1 (100)
2 200
2 250
3 50
3 (50)
3 100

If 1 is 100 and 1 is (100) then highlight , So the result is Highlighted 1
and two lines of 3