+ Reply to Thread
Results 1 to 4 of 4

Return value of cell before first blank cell in a range

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    Engerland
    MS-Off Ver
    Excel 20011
    Posts
    13

    Return value of cell before first blank cell in a range

    I have a small range of cells that contain the text either "Pass", "Fail" or "Not Run". Here's an example:
    E10: Pass
    E11: Pass
    E12: Pass
    E13: Fail

    Another example is:
    E10: Pass
    E11: Pass
    E12: Not Run

    The next row below the "Fail" or "Not Run" is always a blank and in E9 I need a formula that will return the last row result before the blank cell.
    Many thanks

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Return value of cell before first blank cell in a range

    You could try this, but adjust the COUNTA range into a smaller one that you know your data won't exceed:

    Please Login or Register  to view this content.
    Hope this helps!
    Last edited by mcmahobt; 11-18-2014 at 11:37 AM.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    02-26-2013
    Location
    Engerland
    MS-Off Ver
    Excel 20011
    Posts
    13

    Re: Return value of cell before first blank cell in a range

    Thanks mcmahobt, works perfectly

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Return value of cell before first blank cell in a range

    Here is one way.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 1
    Last Post: 09-04-2013, 07:23 AM
  2. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  3. Replies: 5
    Last Post: 03-23-2011, 07:09 PM
  4. Return cell adress for next non-blank cell in a range
    By toreadore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2006, 07:40 AM
  5. [SOLVED] if the value of a cell in a range is not blank, then return the v.
    By kvail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-08-2005, 05:23 PM

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