Depending on what you want to do...


Is the entire row a duplicate?

If so.. Data - Filter - Advanced Filter

Highlight the entire table

Copy to another location

Pick your copy to location

Unique records only

Will delete full dups.

If only column A is a dup then, depends on number of columns.

Can use a pivot table, drop the Header in Row fields to get only unique
records. Can use Column fields to pivot the data and data fields to sum up,
average, etc.


"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.