Deleting Rows
use a datafilter (Data=Filter=Autofilter) on the column to show the True
rows, select the data and do Edit=Delete (entire row). Only the visible
rows will be deleted (don't select the header row). Now turn off the
autofilter (Data=Filter=Autofilter)
--
Regards,
Tom Ogilvy
" wrote in message
...
I have a column of information that contains a list of
numbers. some of these numbers are duplicated and i want
to eliminate them. I sorted these numbers and then used
the =AND(H9=H10) to see which were duplicated (represented
as true). Is there a way to just go through and delete
the rows that are marked as true? Thanks a lot
|