Question description:
This user has given permission to use the problem statement for this
blog.
I need to count unique, non-numeric values from a dynamic column.
Solved by D. L. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/08/2017 - 08:12
Do you have an example of the data and what you are looking for?
Excelchat Expert
10/08/2017 - 08:15
Without more detail, I would say that you should use a countif approach.
Excelchat Expert
10/08/2017 - 08:15
=countif("Dynamic Column name",value to count).
User
10/08/2017 - 08:23
yes one second
User
10/08/2017 - 08:24
from this list i need to count how many unique values there are
User
10/08/2017 - 08:24
from a2 down
Excelchat Expert
10/08/2017 - 08:24
I would use, if(countif() approach.
User
10/08/2017 - 08:25
the problem is the column length and data are constantly changing
User
10/08/2017 - 08:25
=SUMPRODUCT(1/COUNTIF('Shipping data'!C2:C218,'Shipping data'!C2:C218))
User
10/08/2017 - 08:25
that is the current formula i am using
Excelchat Expert
10/08/2017 - 08:25
What is the issue with that formula?
User
10/08/2017 - 08:25
but it does not account for changes
Excelchat Expert
10/08/2017 - 08:25
You mean additions or changes in general?
User
10/08/2017 - 08:26
many times the data will be from say c2:c450, so i need it to automatically count all unique values in all of column c
User
10/08/2017 - 08:26
not just c2:c218
Excelchat Expert
10/08/2017 - 08:26
Can you change your formula to C2:C?
Excelchat Expert
10/08/2017 - 08:26
That'll account for all of C.
User
10/08/2017 - 08:26
it returns an error
Excelchat Expert
10/08/2017 - 08:27
hmm. You can use counta i believe.
Excelchat Expert
10/08/2017 - 08:27
This will likely take another session. Can you please post a new session with Ex_20 in the description?
User
10/08/2017 - 08:28
ok
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.