Dim cel As Range, FindRng As Range, x As Long For Each cel In [M62:AG62] cel.Select Set FindRng = Range(cel, cel.Offset(4)) For Each cel2 In FindRng If cel2 = [A4] Then x = cel.Column - 11 GoTo here End If Next cel2 Next cel here:
|Excel-Find duplicates that ONLY have paticular criteria in another column||21||34|
|Excel Need to return the text of a filter column||11||19|
|Turn several entries on single cell, into individual lines||14||24|
|And OR formula||5||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!