+ Reply to Thread
Results 1 to 5 of 5

Help with an array formula to skip blank cells.

  1. #1
    Registered User
    Join Date
    10-24-2014
    Location
    Santa Barbara
    MS-Off Ver
    Mac 2011
    Posts
    4

    Help with an array formula to skip blank cells.

    Can anyone help with this spreadsheet? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,878

    Re: Help with an array formula to skip blank cells.

    To do what ???? Please explain what you want.

  3. #3
    Registered User
    Join Date
    10-24-2014
    Location
    Santa Barbara
    MS-Off Ver
    Mac 2011
    Posts
    4

    Re: Help with an array formula to skip blank cells.

    Need a formula to skip the blank cells like this:

    COLUMN 1
    -A
    -(BLANK CELL)
    -(BLANK CELL)
    -D
    -E
    -F
    -(BLANK CELL)
    -H
    -(BLANK CELL)



    Result from the formula

    -A
    -E
    -F
    -H


    Thanks

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,878

    Re: Help with an array formula to skip blank cells.

    In A33

    =IFERROR(INDEX($A$2:$A$29,SMALL(IF(B$2:B$29>0,ROW($A$2:$A$29)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

    Enter with Ctrl+Shift+Enter

    Copy across and down

  5. #5
    Registered User
    Join Date
    10-24-2014
    Location
    Santa Barbara
    MS-Off Ver
    Mac 2011
    Posts
    4

    Re: Help with an array formula to skip blank cells.

    Thanks, repped!

+ 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. [SOLVED] Go to right thru a range and skip all blank cells, return value of first non-blank in rang
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2015, 03:47 PM
  2. Array formula to skip cells based on a value
    By carlymcl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2015, 11:20 PM
  3. Fill Down Formula, but skip blank cells
    By jmo1112 in forum Excel General
    Replies: 3
    Last Post: 02-21-2015, 02:22 AM
  4. How to skip blank cells and use formula
    By emp2013 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2014, 08:56 PM
  5. A Formula to skip blank cells (array?)
    By nemo74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 12:44 PM
  6. Replies: 4
    Last Post: 04-09-2012, 12:06 PM
  7. I want to copy a formula n Excel but skip any blank cells
    By Ann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 03:00 PM

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