+ Reply to Thread
Results 1 to 3 of 3

IF formula skipping FALSE cells in results

  1. #1
    Registered User
    Join Date
    04-07-2015
    Location
    Auckland
    MS-Off Ver
    2010
    Posts
    5

    Unhappy IF formula skipping FALSE cells in results

    Hi
    I have master data on one tab (1000 rows, 74 columns). I'd like to create subsets of the data in various tabs based on criteria (Col G - see attachment).

    I tried using IF formula to return the data which works fine until I get a FALSE.

    =IF(Data!$G3="Sport",Data!A3)

    Could you please help with a formula that instead of getting the false the formula looks to the next cell?

    Here is sample of the data attached. The attached example has the main data one the first tab, the second tab gives my formula result in the first 11 rows and shows what ideally I am looking for in rows 14 - 20.

    Thanks in advance for your help .

    Betty
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,235

    Re: IF formula skipping FALSE cells in results

    Hope this helps.... using array formula
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-07-2015
    Location
    Auckland
    MS-Off Ver
    2010
    Posts
    5

    Post Re: IF formula skipping FALSE cells in results



    Thank you so much Azumi. I could not have figured that out by myself...you rock :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Countifs Formula that show True/False results?
    By Kid Wonder in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-12-2013, 12:57 PM
  2. Replies: 4
    Last Post: 05-16-2013, 06:24 AM
  3. Replies: 14
    Last Post: 06-27-2012, 04:26 PM
  4. Printing Cells with TRUE/FALSE results in 1 and 0
    By javaman12 in forum Excel General
    Replies: 4
    Last Post: 04-21-2009, 03:24 PM
  5. Formula that will give me True or False results
    By Reenee in forum Excel General
    Replies: 2
    Last Post: 02-02-2009, 10:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1