Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting duplicated values
There must be a simple method in VB to delete duplicate values. I tried the advancedfilter, but I couldn't get it working. Anyone able to help me out here... -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498266 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting duplicated values
In an adjacent column add the formula
=IF(COUNTIF($A$1:A1,A1)1,"Dup","") then filter by that mew column on Dup and delete all visible rows. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "mariomaf" wrote in message ... There must be a simple method in VB to delete duplicate values. I tried the advancedfilter, but I couldn't get it working. Anyone able to help me out here... -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498266 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting duplicated values
The idea worked and is helpfull indeed. But isn't there an VB solution which is better? Now I have a "Dup" value for each duplicate value and I should delete these values in VB. So I would prefer to combine. So I think I am gonna transform the worksheet code into VB code . Once finished I will post it here for others to use. -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498266 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting duplicated values
Just go through the steps with the macro recorder on
- insert column B - add the formula - add the autofilter - filter the data - delete the visible rows - delete column B It will need tweaking, but you have the basic macro then. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "mariomaf" wrote in message ... The idea worked and is helpfull indeed. But isn't there an VB solution which is better? Now I have a "Dup" value for each duplicate value and I should delete these values in VB. So I would prefer to combine. So I think I am gonna transform the worksheet code into VB code . Once finished I will post it here for others to use. -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498266 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Duplicated Data by Cell | Excel Discussion (Misc queries) | |||
Deleting Rows with data duplicated in 2 columns | Excel Worksheet Functions | |||
duplicated values | Excel Discussion (Misc queries) | |||
deleting duplicated cells in a list via advanced autofilter? | Excel Discussion (Misc queries) | |||
non-duplicated values | Excel Programming |