Count instances of unique text against another column

berrugo74

New Member
Joined
May 15, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
is this what you want?
工作簿1.xlsx
ABCDE
1Computer1Smith-74Computer11
2Computer2Jones-97Computer22
3Computer3Smith-75Computer32
4Computer2Jones-98
5Computer3Smith-74
6Computer2Jones-98
Sheet1
Cell Formulas
RangeFormula
E1:E3E1=SUM((A$1:A$6=D1)/COUNTIFS(A$1:A$6,A$1:A$6,B$1:B$6,B$1:B$6))
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
That is EXACTLY what I want!

What an absolute legend you are... work on Monday seems less daunting now ??...thanks so much!
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top