+ Reply to Thread
Results 1 to 2 of 2

If column 9 blank or 0 do not return result

  1. #1
    Registered User
    Join Date
    07-26-2023
    Location
    Australia
    MS-Off Ver
    365
    Posts
    18

    If column 9 blank or 0 do not return result

    Good morning

    I have a formula that is "=IFERROR(CHOOSECOLS(FILTER(Packing!B4:AW400,Packing!B4:B400=$O$1)*(Packing!C4:C400=$B$2),7,9,10,11),"")"

    However if column 9 is 0 or blank - I want to ignore, (not include this row)

    Can you assist please?

    Thansk

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2407
    Posts
    25,974

    Re: If column 9 blank or 0 do not return result

    Also your syntax in FILTER is off. I have added conditions in red, fixed your syntax in green.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    I cannot try this without your file and your data. If this does not work, please attach a sample file.
    Last edited by 6StringJazzer; 09-26-2024 at 10:36 PM.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Return Blank Result when Cell is Blank
    By clp2473 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2018, 04:23 PM
  2. Replies: 3
    Last Post: 11-22-2016, 08:24 AM
  3. How to return a blank result when using SUM(VLOOKUP formula??
    By Shannon561 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-13-2014, 03:49 AM
  4. Code for VBA VLookup result blank if column index number is blank
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 05:55 PM
  5. Replies: 2
    Last Post: 10-18-2013, 11:18 AM
  6. return blank cell instead of repeating result.
    By tlh1944 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2013, 07:24 AM
  7. [SOLVED] Return blank if lookup result is 0 or NA?
    By Fursmanm in forum Excel General
    Replies: 2
    Last Post: 07-30-2012, 08:56 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