Hi

I have all my raw data on worksheet one and in that I need to cross
reference various peoples names against the various states of
customers. So I need to seperate the 6 names against the 5 states of
customers and produce a figure for each. Can anyone advise?

thanks
James