Thread: Matching cells
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
 
Posts: 83
Default Matching cells

I've simplified my spreadsheet. It now has only two columns (A1 thru
A4841 and B1 thru B18513).

My question is: How do I eliminate the cells in Col B whose 19 left-
most characters do NOT match the 19 left-most characters in the cells
in Col A?