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
[Uploaded an Excel file]
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
[Uploaded an Excel file]
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.