Count unique phrase

Try this workbook to get the ball rolling

1/. Import your data into sheet "2nd" as you normally do. If there is not a header row, then insert a row and give it a header name in A1, say "Text"

2/. Run the macro "RemoveBankRows". This should clear and repopulate sheet "Data".
This step is not required for any real purpose other than a testing backup, and will be integrated into the final code.

3/. Run the macro "Main", this is still a bit slow but it can be improved, once we have an acceptable prototype.

This should handle your original brief, and it has some built in provision for your later requests.

Once you have reviewed this sample.
1/. Do you want "FAILED/4" to be entered in a similar fashion to "RETRY/3"?

2/. I'm not clear about your needs regarding "Device Blocked", do you need something similar to the layout I have for "Device Found"?

3/. Your sample data doesn't cover a wide enough data range to make it clear what you mean in your last post, point 3.
Can you put together a sheet that would clarify this. i.e. maybe a layout as you envisage the results.

I hope this is on the lines you are after.

Cheers.