B
Bob
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
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