Having a repeated concept ones

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

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 don’t 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
 
In B1 insert:
=IF(COUNTIF(A$1:A1,A1)>1,"",A1)

Drag it down completely. However, ignore the blanks or "".
 
One way, using a change event to add to the bottom of col B
Right click sheet tab>view code>insert this. Sort if desired.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Or Target.Count > 1 Then Exit Sub
Set mv = Columns(2).Find(What:=Target, After:=Cells(1, 2), _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)
If mv Is Nothing Then _
Target.Copy Cells(Rows.Count, 2).End(xlUp).Offset(1)
End Sub
 
Hi Mike,

I did what you said but it doesn't work, I copy the code and start including
new data, but nothing happend in column B.

Thanks
 
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
 
Back
Top