Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: Excel 'if' statement.  (Read 2712 times)

0 Members and 1 Guest are viewing this topic.

Calicojack

    Topic Starter


    Newbie

    • Experience: Experienced
    • OS: Windows 7
    Excel 'if' statement.
    « on: November 22, 2013, 06:39:18 AM »
    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,
    Calico
    Logged

    soybean



      Genius
    • The first soybean ever to learn the computer.
      • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Excel 'if' statement.
    « Reply #1 on: November 22, 2013, 07:24:00 AM »
    Why not just sort on the "no" column? 
    Logged

    Chrisxs5



      Hopeful
    • Sup!?
      • Thanked: 8
      • Where we learn IT daily!
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 8
    Re: Excel 'if' statement.
    « Reply #2 on: November 22, 2013, 07:53:11 AM »
    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.
    Logged
    Check out my blog: http://vitrookie.com

    System, Network, Virtualization, Storage, ETC Admin with a bunch of certs and an ego trip!

    soybean



      Genius
    • The first soybean ever to learn the computer.
      • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Excel 'if' statement.
    « Reply #3 on: November 22, 2013, 08:18:52 AM »
    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.
    Logged
    Pages: [1]   Go Up
    « previous next »