Hi Faraz,

It partially works, is important that in column B all the concepts appear
one after the other one, without blank lines in between, your application
look like in the sample below, the only think I need are the concepts one
after the other without blank lines like my initial sample

Column A Column B
Plane Plane
car car
moto moto
bici bici
moto
truck Truck
truck
skii skii
truck
skii
truck
truck

Thanks

"Faraz A. Qureshi" wrote:

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

Drag it down completely. However, ignore the blanks or "".

--
Thanx in advance,
Best Regards,

Faraz


"Maracay" wrote:

Hi Guys

I have this information in column A, the information is repeated and what I
want to have a second column with the information just ones, but I need this
to be synchronized, as soon the user include a new concept in column A I want
that concept in column B, if include a concept that already exist nothing
happen because is already in column B, I dont want the users to go thru
filter option.

I would really appreciate if someone can give me a hand with this.

Thanks



Column A Column B
Plane Plane
car car
moto moto
bici bici
moto Truck
truck skii
truck
skii
truck
skii
truck
truck