Unique list without removing Rows (VBA or Formula)

[MichaelLindsay]

Hi All,

Following scenario, I need to have a unique values list BUT I want to clear the duplicates but preserve the positions...

VBA code or formula or even GUI workaround would be greatly appreciated. Might be a very obvious answer, but I've been scratching my head about it.

Row1 (what I have)	Row2 (what I want)
a	a
a
b	b
b
b
c	c
d	d
d
d
d

<tbody>
</tbody>

<tbody>
</tbody>

 

[johnmpl]

Hi!

	A	B
1	Letters	Answer
2	a	a
3	a
4	b	b
5	b
6	b
7	c	c
8	d	d
9	d
10	d
11	d

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Hoja1​

Worksheet Formulas Cell Formula B2 =IF(A2<>A1,A2,"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

You must copy this formula down.

Please comment!
I hope it helps. Blessings!

 

[Caribeiro77]

in B1

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

 

[Caribeiro77]

I think that With your formula if you type an A for example in cell A5 you get an wrong result...

 

[johnmpl]

I think that With your formula if you type an A for example in cell A5 you get an wrong result...

Yeah! you're right... my formula only works with a sort data (like the example). Your formula works in any time. Blessings!

 

[MichaelLindsay]

Hi johnmpl,

Wow, great thanks so much!

Michael

 

[MichaelLindsay]

Thanks to Caribeiro77 as well. I'm spoilt for choice!