View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kix kix is offline
external usenet poster
 
Posts: 2
Default eliminating unwanted data

Column a has data, column b has data.
I want ap1 to equal q1 if a1 equals b1.
Actually I am looking for a way to eliminate rows if data in one column
appears in
a second column.
Thank you