DataFilterAdvanced Filter.

Check Unique Records Only and Copy to another range


Gord Dibben MS Excel MVP

On Fri, 26 Sep 2008 11:54:22 -0700, red14red
wrote:

thanks sean, worked ike a charm, one more question if you have the time. how
do I delete cells that are duplicates? is there a way to do this?

"Sean Timmons" wrote:

When you say delete them, are you attempting to delete the entire row? If so,
highlight your sheet, then Data - Filter - Autofilter. Pick (blanks) from
column A, highlight your resulting rows Edit - Delete.

"red14red" wrote:

Basic question. I have a huge database in Excel with 8000 names in column A.
Some of these columns are blank. I need to line up all the blank cells and
delte them thus leaving all of the cells with values. Is there a way to do
this other than manually deleting the blank cells. Thanks in advance.