Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Deletion ?
Hello,
Thanks again for All the previous help. Really appreciate it. Using Excel 2007. Have a "big" database of radio frequencies that I really don't want to inadvertently mess up. But, would like to (automatically) Delete duplicates. Would also like to highlight the duplicate values first, before doing any deletions. Column A has the values that I would like to check for duplications. But, I want to delete not only Column A duplicates, but what's on the entire line. e.g., if line 20 and line 40 have duplicate values in column A, then the entire line 20 (or line 40) is to be deleted. I looked at the Duplicate menus, but it's a bit confusing as to how to make sure I get the entire line deleted (rather than what is in the column A cell). How do I do this, please ? BTW: what criteria is used as to how it selects either line 20, or line 40, for the deletion ? Thanks, Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Deletion ?
Hi Bob,
Am Mon, 04 Mar 2013 12:54:07 -0500 schrieb Bob: But, would like to (automatically) Delete duplicates. Would also like to highlight the duplicate values first, before doing any deletions. Column A has the values that I would like to check for duplications. select your column A = Conditional Formatting = Formula and as formula: =COUNTIF($A$1:A1,A1)1 and choose a color to fill. Then Filter = Filter by color and delete the wisible rows Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Deletion ?
Bob submitted this idea :
Hello, Thanks again for All the previous help. Really appreciate it. Using Excel 2007. Have a "big" database of radio frequencies that I really don't want to inadvertently mess up. But, would like to (automatically) Delete duplicates. Would also like to highlight the duplicate values first, before doing any deletions. Column A has the values that I would like to check for duplications. But, I want to delete not only Column A duplicates, but what's on the entire line. e.g., if line 20 and line 40 have duplicate values in column A, then the entire line 20 (or line 40) is to be deleted. I looked at the Duplicate menus, but it's a bit confusing as to how to make sure I get the entire line deleted (rather than what is in the column A cell). How do I do this, please ? BTW: what criteria is used as to how it selects either line 20, or line 40, for the deletion ? Thanks, Bob Just right-click the row label (20 or 40) and choose Delete on the popup menu. In the case of multiplr dupes, hold down the 'Ctrl' while selecting rows to delete. Then right-click any selected row to delete them all at once. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicates, sum column then delete duplicates | Excel Programming | |||
Check for Duplicates then Sum cells of duplicates | Excel Programming | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
name deletion | Excel Discussion (Misc queries) | |||
how do I highlight duplicates cells in excell prior to deletion | Excel Worksheet Functions |