# Excel - COUNT Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a range of cells and would like to use a formula to count the unique values occurring in the range.
Solved by E. B. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/08/2018 - 01:13
Hi
User 16/08/2018 - 01:13
Hi
Excelchat Expert 16/08/2018 - 01:13
do you have an excel you can share?
Excelchat Expert 16/08/2018 - 01:14
or can we just build a sample here
User 16/08/2018 - 01:15
Which ever you prefer
Excelchat Expert 16/08/2018 - 01:15
usually if you have a excel its better as we can build the formula for your data
Excelchat Expert 16/08/2018 - 01:15
if you can share the excel a sample of the file
User 16/08/2018 - 01:16
There you go
Excelchat Expert 16/08/2018 - 01:17
thank you
Excelchat Expert 16/08/2018 - 01:17
do you need the count of uniques numbers or the unique number list?
User 16/08/2018 - 01:19
I'm not sure I understand what the difference is?
Excelchat Expert 16/08/2018 - 01:19
let me give an example
Excelchat Expert 16/08/2018 - 01:20
in the document preview the list of unique values would be Jim,Tim,Ram
Excelchat Expert 16/08/2018 - 01:20
count would be 3
User 16/08/2018 - 01:20
Ah
User 16/08/2018 - 01:20
I need the count
Excelchat Expert 16/08/2018 - 01:20
ok
Excelchat Expert 16/08/2018 - 01:22
Excelchat Expert 16/08/2018 - 01:22
the formula is in B2
Excelchat Expert 16/08/2018 - 01:23
can you verify
Excelchat Expert 16/08/2018 - 01:25
you there
User 16/08/2018 - 01:25
Yes, sorry. Plese give me two seconds.
User 16/08/2018 - 01:26
Yes, that works great! Thank you for your help!

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.