How can I automatically remove duplicate rows in an Excel spreadsheet?
P Peter Downes Dec 30, 2004 #1 How can I automatically remove duplicate rows in an Excel spreadsheet?
B Bob Phillips Dec 30, 2004 #2 Take a look at Advanced Filter. You can do a copy of unique items, and then delete the source. Data>Filter>Advanced Filter and follow the form dialog. -- HTH RP (remove nothere from the email address if mailing direct)
Take a look at Advanced Filter. You can do a copy of unique items, and then delete the source. Data>Filter>Advanced Filter and follow the form dialog. -- HTH RP (remove nothere from the email address if mailing direct)
P Peter Downes Dec 30, 2004 #3 Worked perfectly - thanks Bob Phillips said: Take a look at Advanced Filter. You can do a copy of unique items, and then delete the source. Data>Filter>Advanced Filter and follow the form dialog. -- HTH RP (remove nothere from the email address if mailing direct) Click to expand...
Worked perfectly - thanks Bob Phillips said: Take a look at Advanced Filter. You can do a copy of unique items, and then delete the source. Data>Filter>Advanced Filter and follow the form dialog. -- HTH RP (remove nothere from the email address if mailing direct) Click to expand...
