Dear expert i have country name in column a:a
i want find the occurance of country name in column a result in column b as values 1 for one tiime
2 for second repeat 3 for thrid repeat
for e.g if usa repeat first time in column a result in column b as 1
if usa repeat second time in 5 th row result in column b 5th row as 2
if usa repeat third time in 12 th row result in column b 12 th row as 3
find the attachment
any buddy help on this?
tryYou did ask this in the programming section of the forum, but probably easier to just enter
Please Login or Register to view this content.
=COUNTIF($A$2:A2,A2)
in B2 and fill down.
Last edited by kalak; 08-01-2013 at 10:15 PM.
Dude It works perfectly but
I want change on Same code work for "value not repeat more than once " result as "O"
Dim c As Range
With CreateObject("scripting.dictionary")
For Each c In Range("A1").CurrentRegion.Resize(, 1)
.Item(c.Value) = .Item(c.Value) + 1
c.Offset(, 1) = .Item(c.Value)
Next c
Range("B1") = "Expected Result"
End With
End Sub
Please find the attachment......
Last edited by johnodys; 08-05-2013 at 04:40 AM.
any one help on this?????????
so, maybe like thisPlease Login or Register to view this content.
Thanks Dude Perfect Code !!!!! Keep touch with me dude!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks