Counting Unique Values

[Roy]

Hey everyone,

I have a sheet that contains an ID# in column A, a budget amount in
column B, and a budget description in column C.

For each ID# there are multiple budget amounts. I want to know how to
count the number of unique ID#'s based on criteria for column B or C.

Thanks,

Roy

 

[JE McGimpsey]

Hey everyone,

I have a sheet that contains an ID# in column A, a budget amount in
column B, and a budget description in column C.

For each ID# there are multiple budget amounts. I want to know how to
count the number of unique ID#'s based on criteria for column B or C.

I haven't found a way to do this without a "helper column":

Assume the criteria for columns B & C are in F1 and F2, respectively. in
an unused column, say J, enter:

J1: =A1*(B1=$F$1)*(C1=$F$2)

and copy down as far as needed (you can then hide this column, if you
you wish)

then yor unique items can be returned by

=SUMPRODUCT((J1:J100<>"")/COUNTIF(J1:J100,J1:J100 &""))-1

Note this also assumes that the ID # is numeric.