Sorting data in Excel..

D

dan1001

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
 
J

Jason Morin

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
 
Top