Hi - First Timer here
I have searched for hours and just cannot find exactly what I need here. I have a sheet of data and in Column 'S' there is a list of Reference Codes. I want to find the duplicates in this column but then compare the 'Class' from Column 'G' and only delete the row of the duplicate that is not required. The criteria is :
If the duplicates 'Class' are 'SNMPTrap' and 'Card' delete the row with 'SNMPTrap'
If the duplicates 'Class' are 'SNMPTrap' and 'Switch' delete the row with 'SNMPTrap'
If the duplicates 'Class' are 'Card' and 'Switch' delete the row with 'Card'
If should also not matter if the 'Class' appears in any order on the list ie.
If the duplicates 'Class' are 'Card' and 'SNMPTrap' delete the row with 'SNMPTrap'
The code I have so far is :
It works fine for just 2 rows of Data. As Soon as there is more rows then it fails to find the duplicates.Please Login or Register to view this content.
Help Please!!!
Bookmarks