Use the advanced filter method.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xladvfi....html#FilterUR



Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 06:47:02 -0700, mickeyfinz
wrote:

I have a list of approx 3000 names and fax #'s. Included are about 600
duplicates that I want to delete so I have one name and fax number per line
with no duplications. I have followed the instructions in "HELP" w/o any
success. I was wondering if I am not alone?

"Barb Reinhardt" wrote:

What are you doing? Just select the row you want to delete, right click and
select DELETE.

"mickeyfinz" wrote:

I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
success. Any ideas. M I missing some'ting?