Excel - COLUMN Function Problem - Expert Solution

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.

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

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc