View Single Post
  #1   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.