Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting duplicates
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting duplicates
The following will test the contents of the first 100 rows of Column B if it
is true then the row is deleted. Public Sub dedupe() Dim vx As Long For vx = 1 To 100 If Worksheets("Sheet1").Cells(vx, 1).Value Then Range("A" & vx).EntireRow.Delete Next vx End Sub " 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 ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting duplicates
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting duplicates
That misses some rows in cases where contiguous rows are both/all true
It is best to loop from highest to lowest in reverse Public Sub dedupe() Dim vx As Long For vx = 100 To 1 Step -1 If Worksheets("Sheet1").Cells(vx, 1).Value Then Range("A" & _ vx).EntireRow.Delete Next vx End Sub -- Regards Tom Ogilvy "Nigel" wrote in message ... The following will test the contents of the first 100 rows of Column B if it is true then the row is deleted. Public Sub dedupe() Dim vx As Long For vx = 1 To 100 If Worksheets("Sheet1").Cells(vx, 1).Value Then Range("A" & vx).EntireRow.Delete Next vx End Sub " 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 ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Duplicates | Excel Worksheet Functions | |||
Deleting Duplicates | Excel Discussion (Misc queries) | |||
Deleting Duplicates | Excel Discussion (Misc queries) | |||
Deleting duplicates | Excel Discussion (Misc queries) | |||
Deleting the first row of two duplicates. | Excel Discussion (Misc queries) |