Removing Duplicates while leaving the blanks

[tobetico]

Hi,

I have a column with a set of duplicate values. I need to remove the duplicates while leaving the original data and keeping the blanks. The Remove Duplicates function comprises the data and this does not work for me. Help!

 

[Marcelo Branco]

Hi,

Could you clarify some issues?

-Sheet name
-Data range (column(s), rows)
-Data-type (text, numbers, mixed)
-Expected result

M.

 

[tobetico]

The following is the example of what I would like to achive, I have a lon list of order numbers on Column B, and I would like to see the unique order numbers on column A as follows. Any ideas?

A B
Unique
Order No Order No
8689792 8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8689792
8690850 8690850
8690906
8699723 8699723
8699723
8699751 8699751
8699756 8699756
8699758 8699758
8699769 8699769

 

[Joe Galvan]

Is the following your desired outcome?

A B
8689792 8689792
8689792
8690850 8690850
8690906
8699723 8699723
8699723
8699751 8699751
8699756 8699756
8699758 8699758
8699769 8699769

 

[SaladProblems]

Hi, how do you want to macro it so it deletes them for you, or would a formula suffice?

This formula should do the trick, just copy it into B or whatever column:

=IF(COUNTIF($A$1:A1,A1)>1,"",A1)

 

[tobetico]

-Sheet Name "RawData"
-Data range (B1:B100)
-Data-type (numbers)

 

[tobetico]

The formula did the trick! Thanks a lot!

 

[sudarsan_p]

thats wonderfull,,its worked wonderfully...thanks