Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|