View Single Post
  #1   Report Post  
jolly_lolly
 
Posts: n/a
Default Clearing information in certain columns

I have a big spreadsheet that contains duplicate information in columns A & B
for seveal rows. The information in remaining columns is different. Columns
A & B may contain same information for many rows, then change. I have been
doing a clear contents on columns A & B with duplicate information. There
must be an easier method for clearing duplicate information without
disturbing information in rest of columns.