Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Create another column that sums those categories
(columns) you wish to evaluate, then sort descending based on the new column. For example: =SUM(A2,C2:E2,G2,J2) HTH Jason Atlanta, GA -----Original Message----- Please help.... Entering data to Excel as 1 (yes) or 0 (no) in columns as responses to yes/no questions in the rows. I wish to then identify those columns with yes (1) answers in several categories but not in others. Thank you . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |