Hey,
I'm looking to find out a way to delete duplicates where there are 2 columns of information
I'm not sure of a clear way of explaining this in words, so here's a detailed explanation in a spreadsheet
Thank you for your time and efforts
Bob
Hey,
I'm looking to find out a way to delete duplicates where there are 2 columns of information
I'm not sure of a clear way of explaining this in words, so here's a detailed explanation in a spreadsheet
Thank you for your time and efforts
Bob
Excel 2007 and later versions, allow you to easily delete duplicates. The feature is found in the Data Menu and Data Tools sections.
Select the table and click Remove Duplicates, ensure all columns are checked.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
you have excel 2007 select both columns and use remove duplicates from the data tab
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks