Count Unique Entries

[rajivsoni]

hi...
i have a column wherein i have Customer id's inserted Column A.
Column B has Order Numbers...
I want to count the number of orders placed by a particular Customer.
i tried countif but tht gives me the total count of orders...
Eg. Customer id = 4568
Order Numbers = OR001, OR002, OR001, OR003.

The formula should give me a result of 3 orders placed.
Coz Order number OR001 is repeated twice. it should count only unique orders for tht particular customer.
how can i do tht???
awaiting quick response...
Thanks guys... in advance

 

[VBA Noob]

Try

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

VBA Noob

 

[Aladin Akyurek]

Control+shift+enter, not just enter...

=SUM(IF(FREQUENCY(
    IF($B$2:$B$50<>"",
    IF($A$2:$A$50=E2,
     MATCH("~"&$B$2:$B$50,$B$2:$B$50&"",0))),ROW($A$2:$A$50)-ROW($A$2)+1),1))

where E2 houses a Customer id of interest.

hi...
i have a column wherein i have Customer id's inserted Column A.
Column B has Order Numbers...
I want to count the number of orders placed by a particular Customer.
i tried countif but tht gives me the total count of orders...
Eg. Customer id = 4568
Order Numbers = OR001, OR002, OR001, OR003.

The formula should give me a result of 3 orders placed.
Coz Order number OR001 is repeated twice. it should count only unique orders for tht particular customer.
how can i do tht???
awaiting quick response...
Thanks guys... in advance