Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping data
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping data
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping data | New Users to Excel | |||
Grouping data | Excel Worksheet Functions | |||
Grouping Data | Excel Worksheet Functions | |||
Grouping Data | Excel Worksheet Functions | |||
grouping data | Excel Worksheet Functions |