count unique values & filter
 

This is some sample data:

LOB BC#
Bank BK-1
Bank BK-1
Bank BK-2
Bank BK-1
FPPS FP-1
FPPS FP-1

How do I count the number of UNIQUE BC#'s per LOB? AKA...Bank=2, FPPS = 1

Thanks for your help!!!!!!!!!!!!!

count unique values & filter
 

One way is a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Student
gsnu200702


"paula k" wrote:

This is some sample data:

LOB BC#
Bank BK-1
Bank BK-1
Bank BK-2
Bank BK-1
FPPS FP-1
FPPS FP-1

How do I count the number of UNIQUE BC#'s per LOB? AKA...Bank=2, FPPS = 1

Thanks for your help!!!!!!!!!!!!!

count unique values & filter
 

Assuming that A2:B7 contains the data, let D2 and D3 contain Bank and
FPPS, then try...

E2, copied down:

=SUM(IF(FREQUENCY(IF($A$2:$A$7=D2,MATCH($B$2:$B$7, $B$2:$B$7,0)),ROW($A$2:
$A$7)-ROW($A$2)+1),1))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
paula k wrote:

This is some sample data:

LOB BC#
Bank BK-1
Bank BK-1
Bank BK-2
Bank BK-1
FPPS FP-1
FPPS FP-1

How do I count the number of UNIQUE BC#'s per LOB? AKA...Bank=2, FPPS = 1

Thanks for your help!!!!!!!!!!!!!