Question description:
This user has given permission to use the problem statement for this
blog.
I need to get the number of unique text values that correlate to text values in another column. Example; Column B is the names of account administrators and column C are the names of businesses we work with. We have multiple contacts at each business so business names are listed more than once. There are also some blank spaces that should be excluded.
I want Sheet 2 to simply list the account admins in cloumn A and the number of businesses they work with (unrepeated) in column B
Solved by K. H. in 34 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/04/2018 - 06:49
Hi there
User
03/04/2018 - 06:49
Hello
Excelchat Expert
03/04/2018 - 06:49
How are you and how may i assist you with today?
User
03/04/2018 - 06:50
I need to get the number of unique text values that correlate to text values in another column. Example; Column B is the names of account administrators and column C are the names of businesses we work with. We have multiple contacts at each business so business names are listed more than once. There are also some blank spaces that should be excluded. I want Sheet 2 to simply list the account admins in cloumn A and the number of businesses they work with (unrepeated) in column B
Excelchat Expert
03/04/2018 - 06:50
Okay, i will try my best to help you out with this
Excelchat Expert
03/04/2018 - 06:50
Can you share me a sample worksheet
Excelchat Expert
03/04/2018 - 06:50
So that we both can have a better evaluation to the issue
User
03/04/2018 - 06:52
Can you see what I'm doing?
Excelchat Expert
03/04/2018 - 06:53
Yep, please go ahead
User
03/04/2018 - 06:54
We can work on one sheet for convineice
Excelchat Expert
03/04/2018 - 06:54
Okay, cool
User
03/04/2018 - 06:57
Do You understand what I'm looking for?
Excelchat Expert
03/04/2018 - 06:58
yep
Excelchat Expert
03/04/2018 - 06:59
like for "Chad" we should get 2 right?
User
03/04/2018 - 06:59
Correct
User
03/04/2018 - 07:00
Victoria should be 3 and charles should be 1
Excelchat Expert
03/04/2018 - 07:01
yep as you changed it now
Excelchat Expert
03/04/2018 - 07:01
will get a formula to do that
User
03/04/2018 - 07:01
Awesome!
User
03/04/2018 - 07:06
Find anything?
User
03/04/2018 - 07:06
Thanks btw!
Excelchat Expert
03/04/2018 - 07:06
just a bit more
Excelchat Expert
03/04/2018 - 07:10
Got it
User
03/04/2018 - 07:10
yay!
Excelchat Expert
03/04/2018 - 07:11
will share you the sheet shortly
User
03/04/2018 - 07:11
ok
Excelchat Expert
03/04/2018 - 07:11
please have a look
[Uploaded an Excel file]
Excelchat Expert
03/04/2018 - 07:12
is it nice
Excelchat Expert
03/04/2018 - 07:13
its done in using Pivot Table
User
03/04/2018 - 07:14
it's not counting unique business names. Just total names
User
03/04/2018 - 07:17
See my pivot table
User
03/04/2018 - 07:17
It's the same as yours
Excelchat Expert
03/04/2018 - 07:18
yes i see
User
03/04/2018 - 07:18
But it only shows the total number of businesses
User
03/04/2018 - 07:19
not unique businesses... so it counts copies giving an inaccurate number
Excelchat Expert
03/04/2018 - 07:23
Have a look to this
[Uploaded an Excel file]
Excelchat Expert
03/04/2018 - 07:23
consider the last column for count
Excelchat Expert
03/04/2018 - 07:23
Column J
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.