View Single Post
 
Old 09-03-2014, 09:46 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote