macro or function
 

A B C
D E

Code Code
Code Code
1 Customer HU HM
DR FN


2 Jill Cane 1
1 1


3 Joe Carter 1 1


Now I want to be able run a macro or function that will tell me how
many Codes Jill Cane has based on the number of "1's" she has
underneath each code. So if there is a one under "Code HU" for Jill
then she has code HU. So in this example, Jill Cane would have Codes,
HU, DR and FN, and I want to be able to summarize that for Jill Cane.

Can someone please help.

ssrvant