ExcelBanter - Grouping data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Grouping data (https://www.excelbanter.com/excel-discussion-misc-queries/214406-grouping-data.html)

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"mark" wrote:

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?