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
.
|