I have a rather large xls full of customer data. I'm trying to produce
some charts based on the data. THe problem I'm facing is that the data
is non-numerical and I have little experience manipulating this type of
data.

I have several columns, such as State, MaritalStatus, and the like,
that I would like to find out info about, such as the percentage of
customers in each state.

How do I even begin to do this? Thanks for any helP!


--
chornbeck
------------------------------------------------------------------------
chornbeck's Profile: http://www.excelforum.com/member.php...o&userid=35451
View this thread: http://www.excelforum.com/showthread...hreadid=552270

I don't have much experience with non-numerical data, but I have used this
befo

=COUNTIF(B2:B21,"sc")

If sc appears in the given range, it will count it. Divided by the number
of customers*100 (=C2/(COUNTA(A2:A21))*100) will give you the percentage of
customers in sc...

"chornbeck" wrote:


I have a rather large xls full of customer data. I'm trying to produce
some charts based on the data. THe problem I'm facing is that the data
is non-numerical and I have little experience manipulating this type of
data.

I have several columns, such as State, MaritalStatus, and the like,
that I would like to find out info about, such as the percentage of
customers in each state.

How do I even begin to do this? Thanks for any helP!


--
chornbeck
------------------------------------------------------------------------
chornbeck's Profile: http://www.excelforum.com/member.php...o&userid=35451
View this thread: http://www.excelforum.com/showthread...hreadid=552270