Comparing Fields in Different Columns

  • Thread starter Thread starter Guggenheim
  • Start date Start date
G

Guggenheim

I was wondering if there is a way two compare the fields in 2 different
columns. Then if those fields are identical they would be removed. Is
there a basic function to do this or do I need to write a macro?
Thanks for the help.
 
Hi.........

Assuming your columns are A and B, in cell C1 put this formula and copy it
down column C

=IF(A1=B1,1,"")

then sort on column C and delete all the rows that have a 1 in column C

And, if you do this frequently, it could be recorded into a macro........

Vaya con Dios,
Chuck CABGx3
 
Back
Top