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!