Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am checking for duplicates in a workbook. The following is the code I'm
using: lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = lr To 1 Step -1 With ActiveSheet If Cells(i, 11) = Cells(i + 1, 11) _ And Cells(i, 6) = Cells(i + 1, 6) _ And Cells(i, 4) = Cells(i + 1, 4) _ And Cells(i, 5) = Cells(i + 1, 5) Then Cells(i, 12) = Cells(i, 3) + Cells(i + 1, 3) End If End With Next This works if there is only one duplicate entry, but I can have multiple duplicate entries. I need to sum all of the column C cells for each duplicate found. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
check for duplicates | Excel Discussion (Misc queries) | |||
Check duplicates | Excel Programming | |||
All cells shud contain a unique ref how do i check 4 duplicates? | Excel Worksheet Functions | |||
Check for Duplicates | Excel Worksheet Functions | |||
Check for duplicates | Excel Worksheet Functions |