Help with a formula

[Prit]

Hi Guys,
I need help in writing a formula. I have a spreadsheet which contains
reference numbers in one column, some of which are duplicates. I want to
write a formula which allows me to get rid of duplicate numbers by replacing
any duplicates with blanks so if cell a1 is the same as cell a2, bring me
back blanks but keep one of the values.

Hope you can help!

 

[Bob Phillips]

=IF(A1=A2,"",A1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Prit]

Brilliant stuff....thanks Bob. This worked like a dream and will definitely
make my job much easier.