Hi,
I have rather large list of customer addresses and I want to know how many
are in each state. Then I would like to take that information and paste it on
another sheet. What function I would I use to that.

Thanks,