Counting cells with duplicate values
 

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?

Counting cells with duplicate values
 

Try creating a pivot table with the data an dragging the column of interest
into the row region of the table. Using the layout feature in the pivot
table wizard will make it a little easier.

Regards...

"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?

Counting cells with duplicate values
 

Data---Filter---Advanced Filter

"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?

Counting cells with duplicate values
 

I use Jim Cone's fine commercial Add-in for things like this. It's available
at

http://www.realezsites.com/bus/primitivesoftware/

hth
Vaya con Dios,
Chuck, CABGx3




"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?

Counting cells with duplicate values
 

With data in A1 to A100, try this:

=SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&""))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Carla" wrote in message
...
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?

Counting cells with duplicate values
 

"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.