Deleting Rows
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 |
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 |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com