Is there a way in 2007 to delete rows based on duplicate values in a single column? Thanks. The dups are number values
Is there a way in 2007 to delete rows based on duplicate values in a single column? Thanks. The dups are number values
Hi,
Do you want to delete all duplicate values or just the second and subsequent occurencies?
If the latter one way is to use a helper column and add the formula =COUNTIF($A$1:$A1,A1) and copy it down. Then filter the helper column for values >1 and select and delete all the filtered rows.
If the former then use COUNTIF($A$1:$A$100,A1), change the last row 100 as appropriate and copy, filter, select and delete as above.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
You could also attach a sample workbook so that its easier to understand what kind of data. And Richard's question -is important too...Do you want to delete all duplicate values or just the second and subsequent occurencies?
there is a remove duplicates option on 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
Thanks Martin,
You've reminded me of something new in 2007 - which I suspect is often overlooked or forgotten, as I have demonstrated
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks