Sorting data in Excel..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare identifier columns from 2 sheets - remove rows that are dups 2
Prefilled Outlook Yes Voting Button response 0
sorting noncontiguous data with exceptions 3
How to compare a row data from one worksheet to another worksheet 5
Sorting day names chronologically 5
Difference between these two formulas? 5
Count and Sum functions with 2 criterias 20
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1

Back
Top