Help with a formula
 

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!

Help with a formula
 

=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" wrote in message
...
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!

Help with a formula
 

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

"Bob Phillips" wrote:

=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" wrote in message
...
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!