Grouping data

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

I have data in Excel 2003 in the format of true/false dichotomies for 15
different characteristics in 15 columns. I want to show which characteristics
occur together. Doesanyone know how to do this? I had thought of creating a
new column containing all true data but cannot make thiswork. Can anyone help?
 
For grouping data like that, your best bet might be to use a PivotTable.

Data->PivotTable

Setup your names/labels as rows, and your True false columns as either data
or columns, whichever looks better for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Excel tell me what groups i have? 1
Alphabetizing Column without losing corresponding data? 2
How can I retain the formatting of the data in a lookup table? 1
Practice Test Using Excel 1
Reference Formula Help 1
transfer data from 3x15 grid to a single list? 3
CSV imported data being formatted as a date 2
can't paste from clipboard in my macro 1

Back
Top