Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to determine if a row is a duplicate based on two criteria. This
is what I have so far, but it doesn't work. Any pointers much appreciated! sub tester Dim iLastRow As Long Dim i As Long Dim rName1 As Range Dim rName2 As Range Dim rTestRng As Range iLastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For i = iLastRow To 1 Step -1 ' it's a dup if there are two rows in which columns C match AND columns J ' match Set rTestRng = Union(.Cells(i, "c"), .Cells(i, "j")) If Application.CountIf(Union(.Range("c1:c" & iLastRow), ..Range("j1:j" & iLastRow)), rTestRng) = 2 Then ' do some stuff here else ' do something else end if next i end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
duplicate name help please | Excel Worksheet Functions | |||
Duplicate | Excel Discussion (Misc queries) | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Duplicate Row | Excel Programming | |||
duplicate | Excel Discussion (Misc queries) |