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!!!!!!!!!!!!!