Need to edge out the competition for your dream job? Train for certifications today.
For Idx = 1 To 82
Set Rng = Range(Range("L2"), Range("L" & Rows.Count).End(xlUp))
For Each c In Rng
If Idx1 < Idx And c.Offset(, 1) = "" And c = WorksheetFunction.Large(Rng, Idx) Then
c.Offset(, 1) = 1
Idx1 = Idx1 + 1
Open in new window
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.