How to blank out cells with duplicate values?

Giganews Newsgroups
Subject: How to blank out cells with duplicate values?
Posted by:  Bleu_808 (bleu_8…@yahoo.com)
Date: 1 May 2006

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