Best solution for removing duplicate content with conditions?

P

popflier

Could someone tell me the best way to go about doing the following?

I am exporting an excel sheet from another piece of software. On this excel
sheet I have one column with a header called "Names" and a list of 600 names
below it. Each of those names are in their own row. I have a second column
next to the first that is labeled "Attn." It too has a list of names that are
each on their own row. The names that are listed in each column should be
different. However, after exporting from this other software to excel some of
the names are duplicated and I will have the same name listed in both columns
within the same row.

How can I tell excel....

If the content in the "Names" column is the same as the content within the
"Attn" column and both are in the same row then delete the content in the
"Attn" column in that row.

Is this possible for me to do in Excel?
 
D

Dave Peterson

You could add a formula in C1:

=a1=b1
and drag down.

This will return TRUE if both values are equal.

Then you can filter by this column (add headers if you need to).

Show the TRUE's and delete the visible rows.

Then remove the filter and delete that helper column.
 
P

popflier

Got it! Thank you!

Dave Peterson said:
You could add a formula in C1:

=a1=b1
and drag down.

This will return TRUE if both values are equal.

Then you can filter by this column (add headers if you need to).

Show the TRUE's and delete the visible rows.

Then remove the filter and delete that helper column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top