Hi guys,
Can anyone please assist me with an urgent thing for work...?
I have a list of computer names in Column A and in Column B a name. I need to count how many different people have logged on to each computer.
I have all the raw data with all the log on info on one tab, which is loads of computer names and the different users logging on. On another tab, I have a list of just my unique computer names. I am really struggling to do a count how many different names (Smith-74, Jones-97) have used each computer (COMP001) in the list.
So, my perfect output would be a list of my computer names with a value next to it...
Comp NAME COUNT of different Users
COMP001 2
COMP002 9
Clear as mud?...can anyone help please?
Many thanks in advance
Can anyone please assist me with an urgent thing for work...?
I have a list of computer names in Column A and in Column B a name. I need to count how many different people have logged on to each computer.
I have all the raw data with all the log on info on one tab, which is loads of computer names and the different users logging on. On another tab, I have a list of just my unique computer names. I am really struggling to do a count how many different names (Smith-74, Jones-97) have used each computer (COMP001) in the list.
So, my perfect output would be a list of my computer names with a value next to it...
Comp NAME COUNT of different Users
COMP001 2
COMP002 9
Clear as mud?...can anyone help please?
Many thanks in advance