Hi
looking VBA code for Keeping only first unique rows
in column B & C have some information
Column C having duplicate content
I want to keep only first unique value of column C like as image
result comes with like by line
ie: deleting in between red color values , next red color row comes to B2C2 ,B3C3 likes as
test_unique.PNG
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
information in only B &C , Activesheet.cells means entire sheet duplicate removed , I tried below not working please help me.
Sub DeleteDups()
ActiveSheet.Columns("B:C").RemoveDuplicates Columns:=3, Header:=xlNo
End Sub
Try:
Please Login or Register to view this content.
Before removing duplicate, I want to extract only two times repeated values from column B to column D please help
I'm sorry but I don't understand what you want to do. Please explain in detail referring to specific cells, rows and columns using a few examples from your data. Also attach a copy of your file (de-sensitized if necessary) that shows your expected result. See the yellow banner at the top of this page for instructions to attach a file.
The above code is working fine thanks
I having another addon help.I'm my first post have image attched in that image coloumn B Having same values comes multiple times for Pls assume example B1 and B5 same vlaue its 5 times repeated. I want the results only 5 times repeated values should be extracted to D COLOUMN the extracted value should be unique. please help to solve this
Please see my response and request in Post #6.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks