Thread: Inserting a row
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Inserting a row
Or without VBA...
Enter this formula at B2 and copy down:
=--(A1=A2)
Copy Paste Special Value
Go To Special Column Differences
Insert Entire Row

Reply With QuoteReply With Quote