"Carla" wrote:

I have a large file which I have downloaded from our company database. I
want to be able to count only the unique values in a specific column. Right
now there are blank cells and duplicate values. How do I do this?

You might find it useful to use Excel's Filter feature. For simplicity, copy and paste the specific column you want to work with into a new worksheet. Then go to Data, Filter, then Advanced Filter. Identify the column that you are working with in the List Range Column (e.g. $A$1:$A$157). I recommend selecting Copy to New Location and then selecting the Adjacent column (e.g. $B$1). Check the box for Unique records only then OK. Next use a simple =COUNT(B2:B17) function to get your count.

Note: Filter may count some cells that look the same as unique if there are
spaces before of after. One strategy may be to clean your data up using
trim into a new column then cut and paste these trimmed values only into a
new column.

I realize this is a less glamorous approach than a sophisticated formula,
but I have found this to be a simple to use workaround as a solution to
problems such as this.