Hoo boy...you lost me there. But anyway, let's see if this works...
Insert another column after B. In the first row, enter 1. In the second row:
=IF(A2=A1,C1+1,1)
Now you have a unique key for each line consisting of Columns A and C. All you have to do now is filter Column C to only show those records with a value of 1.
|