Sorting data in Excel..
 

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

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
.