# Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at