I have an Excel file with server names in column A and and errors in column D. I want to create a list of servers that contain specific text from column D.
Say I have 50 servers. In the error list I want to know how many servers have the error reading " Account Lockout Threshold" so I can identify which ones need to be remedied of this particular issue. The D column has multiple lines of text with errors. Does anyone have any ideas on how I can isolate each error and identify each server with this error?
I've attached the file for referencing.