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


"Guggenheim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>