Delete Dups
Hi,
I assume this word 'Duplicate' is from a countif formula. If you are trying
to delete duplicates from a column then I wouldn't start from there!!
Select your column with duplicates in then
Data|Filter|Advanced filter
Select 'copy to another location'
Check 'Unique records only'
enter a cell address to copy them to
OK and you now have a unique list to paste on top of the list with
duplicates in
Mike
"Stockwell43" wrote:
Hello,
I have a spreadsheet that has a column that says "Duplicate?". I am trying
to delete thse as there are over 6,000 rows I hate to do this manually. How
can I delete the ones that say Dup in the cell either at once or doing a find
and delete?
Thanks!
|