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