Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
my problem is that I have a list with duplicate entries and values attached to them like this: col a col b 12 2 12 3 14 5 I'm searching for a macro that would turn my list into this: col a col b 12 5 14 5 Or like this: col a col b col c 12 2 3 14 5 So if you could please help me, I would be very grateful! Please respond also to my email because I have had problems entering the community and finding spicific threads. -Dave |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I prefer the latter
Public Sub ProcessData() Dim i As Long Dim iLastRow As Long With ActiveSheet iLastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For i = iLastRow To 2 Step -1 If .Cells(i, "A").Value = .Cells(i - 1, "A").Value Then .Cells(i, "B").Resize(, _ .Cells(i, .Columns.Count).End(xlToLeft).Column - 1).Copy ..Cells(i - 1, "C") .Rows(i).Delete End If Next i End With End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave" wrote in message ... Hi, my problem is that I have a list with duplicate entries and values attached to them like this: col a col b 12 2 12 3 14 5 I'm searching for a macro that would turn my list into this: col a col b 12 5 14 5 Or like this: col a col b col c 12 2 3 14 5 So if you could please help me, I would be very grateful! Please respond also to my email because I have had problems entering the community and finding spicific threads. -Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to remove duplicates and combine their unique values? | Excel Discussion (Misc queries) | |||
check for duplicates, then sum unique values | Excel Discussion (Misc queries) | |||
Count Unique Values In A Filtered Row with Duplicates | Excel Discussion (Misc queries) | |||
Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
Duplicates - deleting to get just unique ones | New Users to Excel |