See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
Sub DeleteDupRows() Dim i Dim J Dim RowsA Dim Val1 Dim Val2 Application.ScreenUpdating = False RowsA = Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To RowsA Val1 = Cells(i, 2) For J = i + 1 To RowsA Val2 = Cells(J, 2) If Val1 = Val2 And Cells(i, 13) = "No Constraints" Then Rows(J).EntireRow.Delete End If Next J Next i Application.ScreenUpdating = True End Sub
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!