kriftsi
asked on
Using Excel to Create the customers profile
Hello
I have an excel sheet like this example
Name City State Age Occupation
Jack Boston MA 25-40 Student
Paul Miami FL 40-50 Vetern
Nick Boston MA 40-50 Veteran
Nick Los Angeles CA 25-40 Business owner
I want to filter the spreadsheet in an order to be able to create the customer profile for example how many register from a specific State what is the average age and occupation. After that a want to create a pie diagram to present the results.
thank you
I have an excel sheet like this example
Name City State Age Occupation
Jack Boston MA 25-40 Student
Paul Miami FL 40-50 Vetern
Nick Boston MA 40-50 Veteran
Nick Los Angeles CA 25-40 Business owner
I want to filter the spreadsheet in an order to be able to create the customer profile for example how many register from a specific State what is the average age and occupation. After that a want to create a pie diagram to present the results.
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Excel 2003 and earlier will vary somewhat because there is no Table feature. You can use a dynamic named range instead with a Refers to formula like:
=$A$1:INDEX($E:$E,COUNTA($
If the wizard uses a fixed address for the data, replace it with the name of the Table (or the dynamic named range).
If you add, delete or change data, you will need to right-click your charts and choose Refresh to get them to update.