Find duplicate entries

I have two columns in an Excel spreadsheet that consist of an address in each
column. Most of the addresses are identical but I wish to find the rows
where the addresses are not identical.

Is there a way to do this.

Thanks for any help.
Kris

Hi,
Assuming that you know that the addresses to be compared are on the same row(s), you could try a simple IF statement in an adjacent column like this:

=IF(A3=C3,"ok","ERROR")

If you have a lot of addresses, you could then filter on the new column and select the ERROR cells.

-- George

Hi,

One way would be to conditional format one column so it highlights if it
doesn't equal the corresponding cells in the other column.

HTH
Ron

"kharrison" wrote:

> I have two columns in an Excel spreadsheet that consist of an address in each
> column. Most of the addresses are identical but I wish to find the rows
> where the addresses are not identical.
>
> Is there a way to do this.
>
> Thanks for any help.
> Kris

Can you explain how I would go about doing that.

Thanks

"Airfive" wrote:

> Hi,
>
> One way would be to conditional format one column so it highlights if it
> doesn't equal the corresponding cells in the other column.
>
> HTH
> Ron
>
> "kharrison" wrote:
>
> > I have two columns in an Excel spreadsheet that consist of an address in each
> > column. Most of the addresses are identical but I wish to find the rows
> > where the addresses are not identical.
> >
> > Is there a way to do this.
> >
> > Thanks for any help.
> > Kris

If you want help working with duplicates, take a trip to Chip Pearson's
site:

http://www.cpearson.com/excel/duplicat.htm

He has a bunch of techniques for working with duplicates.

kharrison wrote:
>
> I have two columns in an Excel spreadsheet that consist of an address in each
> column. Most of the addresses are identical but I wish to find the rows
> where the addresses are not identical.
>
> Is there a way to do this.
>
> Thanks for any help.
> Kris

--

Dave Peterson