Count #of times an ID(name) appears and place the value in another column

[SeanDD]

Did a search, but did not find an answer that appeared to be what I was looking for.
I have a weekly report that is sent to me (.csv file), the report is 8 rows long and 8 columns wide (A-H).
The table essentially looks like this:

[TABLE="width: 300"]
<tbody>[TR]
[TD]Date:[/TD]
[TD]2/16/2018[/TD]
[TD]blank[/TD]
[TD]Time[/TD]
[TD]7:00:00[/TD]
[TD]blank[/TD]
[TD]System Name:[/TD]
[TD]XXCCDS[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]XXCCDS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Operator[/TD]
[TD]GNE\caguyonj[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Action[/TD]
[TD]Startup[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Comment[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Revision[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Location[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Seq Number[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Depending on how many users (operators) log on and log off during a week, this report could be extremely long.
What I'm trying to do is determine how many times a specific 'operator' shows up within a weekly report. I thought of using a vlookup, but I do not have a table in which to base my 'lookup' information off. 'Operators' are constantly being added and removed with their own specific 'ID'.
Is there anyway in which I could input a formula in which in another column it would show me the 'Operator' ID and the number of times their ID shows up within the report next to their name?
If this is beyond what a 'newbie' should be working on, I understand, just finding more and more tasks in which Excel is very useful to me in this job.
Thank you for any assistance.

 

[SeanDD]

Believe me when I say, I'm not being critical, this is awesome what you sent. I'm just trying to see why it appears to count and place the same data twice over in the right hand column. This is great learning for me, I'm just not at this level yet. This is what I'm trying to figure out why it is counting, and/or placing it twice.
[TABLE="width: 922"]
<colgroup><col><col><col span="4"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date:[/TD]
[TD="align: right"]2/20/2018[/TD]
[TD][/TD]
[TD]Time:[/TD]
[TD="align: right"]17:36:26[/TD]
[TD][/TD]
[TD]System Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD]#[/TD]
[TD]OperatorID[/TD]
[TD]Number of actions[/TD]
[/TR]
[TR]
[TD]Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]GNE\dempsays[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Operator:[/TD]
[TD]GNE\dempsays[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]GNE\dempsays[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Action:[/TD]
[TD]Startup[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]GNE\bernaldf[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Comment:[/TD]
[TD="colspan: 3"]Main Menu successful user logon[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]GNE\bernaldf[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Revision:[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]GNE\mendezr3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Location:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]GNE\skacelj[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Seq Number:[/TD]
[TD="align: right"]473480[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]GNE\sharpn[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD]GNE\sharpn[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Date:[/TD]
[TD="align: right"]2/20/2018[/TD]
[TD][/TD]
[TD]Time:[/TD]
[TD="align: right"]17:36:26[/TD]
[TD][/TD]
[TD]System Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD]9[/TD]
[TD]GNE\shnaydes[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]GNE\shnaydes[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Operator:[/TD]
[TD]GNE\dempsays[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]GNE\mendezr3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Action:[/TD]
[TD]Startup[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD]GNE\mendezr3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Comment:[/TD]
[TD="colspan: 3"]Main Menu successful user logon[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]13[/TD]
[TD]GNE\karkis[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Revision:[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]14[/TD]
[TD]GNE\biekk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Location:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]15[/TD]
[TD]GNE\biekk[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Seq Number:[/TD]
[TD="align: right"]473479[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD]GNE\isaacsj[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]17[/TD]
[TD]GNE\isaacsj[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Date:[/TD]
[TD="align: right"]2/20/2018[/TD]
[TD][/TD]
[TD]Time:[/TD]
[TD="align: right"]17:21:59[/TD]
[TD][/TD]
[TD]System Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD04[/TD]
[TD]18[/TD]
[TD]GNE\patelg6[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Name:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD04[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]19[/TD]
[TD]GNE\dionellm[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Operator:[/TD]
[TD]GNE\bernaldf[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[TD]GNE\cantoj1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Action:[/TD]
[TD]Shutdown[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[TD]GNE\cantoj1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Comment:[/TD]
[TD="colspan: 2"]Main Menu shutdown[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]22[/TD]
[TD]GNE\clinej2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Revision:[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23[/TD]
[TD]GNE\clinej2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Location:[/TD]
[TD="colspan: 2"]CTXSSFBASPRD04[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]24[/TD]
[TD]GNE\sharpn[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Seq Number:[/TD]
[TD="align: right"]473277[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]GNE\cantoj1[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]


I modified the range to accommodate all of the data, but how it is obtaining the data at first is what I'm looking through my excel book to figure out. The whole report is about 4000 cells long. It took that data just fine, but the question is why ID's are showing up twice with the same overall count.

 

[trimmjens]

The left column is just listing all the user ID's in sequence as they appear in the log. The right column is just a countif formula to count how many times each user ID shows up.