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.

 

[trimmjens]

Hi,

This example you've shown here is for one user only, right? How will the table look if you have for example 5 users in it?

 

[SeanDD]

Sorry, feel a little stupid now. That is where my issue really is, this report will have over 50 different possible users 'Operators'. The real piece of data I'm looking at is the Operator. How often they show up and the ability to count how often the name shows up.
So, yes, my example only showed one user, but their will be quite a few different user names to count and sort.

 

[trimmjens]

You can count the number of times a value occours in a range with the formula:

=COUNTIF(A1:H8;J1)

Where you type in the OperatorID in cell J1. But this is maybe not what you want?

 

[SeanDD]

I do not have a list of Operators that I can reference and ensure that the list will always be up to date. Otherwise I believe I could use vlookup if I had a list. This is the issue, using countif and a wildcard at the end of GNE\* will provide me the number of Operators with the prefix of GNE\, but I also need to separate each individual Operator per their own ID.
Appreciate all the help

 

[trimmjens]

I understand your wish. I don't think you can do this with a formula. But you can do a lot more with vba if that is an option.

 

[SeanDD]

if VBA is another term for an excel macro, than yes, it is an option. I have an excel book and will have to see if it can show me a way to solve this issue.
Thanks again,

 

[trimmjens]

I've worked out an example for you, but i'm not sure if it will fit you sheet. But you can have a look at it and see if you can modify it so if fits your sheet.

https://drive.google.com/file/d/1Yh0Ao4ui8nKdYgmX4CwjNTQhnMPZ26eh/view?usp=sharing

See if you can download this excel file and have a look at it.

 

[SeanDD]

That is nice Trimmjens. It does fit my sheet, but there are some counting issues I will need to work out. the way it's counting seems strange, but I'm going to put a little time towards it and see if I can understand how this thing works.
Hopefully I can get this to work while presenting the data in a correct format.

Thank you very much.

 

[trimmjens]

I know the way the code prints the list is not perfect. But I just made an idea so that you can work out a better way.
If you have other questions I'll try to help.

Thomas