1.

Solve : Excel 'if' statement.?

Answer»

Hey Guys,
I have an issue that NEEDS to be addressed. I have a worksheet with 380 rows of yes/no questions. I need to summarize the yes no answers on SHEET 2. What I want to do is list the questions, (in an organized fashion) That have been answered with a 'no'. BTW, Macros are not an OPTION!
Thanks for any help,
CalicoWhy not just sort on the "no" column?  Have tried an Auto-filter? On the Data, click on filter. It will set your top row with options to filter. Select your column and filter to no or yes. Quote from: Chrisxs5 on November 22, 2013, 07:53:11 AM

Have tried an Auto-filter?
... which is a way of sorting.  Very useful tool.


Discussion

No Comment Found