RE: How to blank out cells with duplicate values?

Giganews Newsgroups
Subject: RE: How to blank out cells with duplicate values?
Posted by:  Gary''s Student
Date: Mon, 1 May 2006

Try:
1. select the column
2. pull-down:
Data > Filter : Advanced Filter > and check unique records only

This should eliminate the duplicates

--
Gary's Student

"Bleu_808" wrote:

> Okay - after an hour on trying to work on what I thought was an easy
> task 0 I must ask for help!
>
> My column A is a list of order numbers, each order is separated by a
> blank row...
>
> ex:
> 1234
> 1234
> 1234
> 1234
>
> 4321
> 4321
> 4321
>
> 6789
> 6789
>
> What I would like to do is delete the duplicate order numbers, without
> affecting the rest of the row.  I thought this might be a simple if
> statement, but no.  Any ideas?
>
> Thanks in advance - Bleu

Replies

In response to

How to blank out cells with duplicate values? posted by Bleu_808 on 1 May 2006