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
 

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
Having a 'not applicable' with a 0 ranking on a rating question 0
Excel - Wich Function should I use? 1
Autonumber field in Excel that behaves the same as Access 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Need Help with a VBA subroutine 0
Populate a table based on check box status 2
Remove specific cells in a column. 2

Top