How to insert column values for specific rows

[yyl05]

Hi everyone,

I currently have a csv file that consists of 600,000plus rows of data
I would like to insert value 'Malicious' into the column H, 'Class' for all rows of data that contains values 147.32.84.180 or 147.32.84.170 which appears in either column C or column D, and value 'Bakground' for all other values
Pictured below is an example of the first few rows which has column H filled, and I have a few hundred thousand more that I would like to fill up.

I have tried using the filter function on both columns C and D each to filter out the rows containing the values, however it led to an error where its not displaying all values in the column. The error states that as there are more than 10,000 unique values, only the first 10,000 are displayed.


Any suggestions on how I can do this??
Thank you so much for your time

 

[sheetspread]

Can you copy the column, and insert or paste it to the right of column H, then with ctrl-h replace 147.32.84.180 with malicious? Otherwise an If formula can do this.

 

[Fluff]

Try this

Sub MaliciousIP()
   With Range("H2", Range("G" & Rows.count).End(xlUp).Offset(, 1))
      .Value = Evaluate(Replace(Replace("if(@C="""","""",if((@C=""147.32.84.180"")+(@C=""147.32.84.170"")+(@D=""147.32.84.180"")+(@D=""147.32.84.170""),""Malicious"",""Backround""))", "@C", .Offset(, -5).Address), "@D", .Offset(, -4).Address))
   End With
End Sub

 

[yyl05]

Thanks everyone for your quick replies and suggestions, I managed to solve it using the IF formula