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