+ Reply to Thread
Results 1 to 3 of 3

Return values in the first and subsequent non blank cells

  1. #1
    Registered User
    Join Date
    06-24-2020
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    7

    Return values in the first and subsequent non blank cells

    Please refer to the attachment.

    I am looking for functions which will return the values in the first and subsequent non blank cells.

    The attached workbook is about recording observations of babies who are born prematurely. The range B18:D22 require functions which find eg the first observation date and the data relating to that observation date, then the next observation date and the data relating to that observation date etc. The actual observation dates recorded in row 9 need to be the starting point for the functions in the range B18:D22. The process the user expects to follow is: enter the actual observation date then choose observation code.

    The actual workbook contains far more data collection and helper cells than this "public" cut down version.

    Many thanks for the help you can provide.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,278

    Re: Return values in the first and subsequent non blank cells

    Try in B18:

    Please Login or Register  to view this content.
    C18
    Please Login or Register  to view this content.
    D18
    Please Login or Register  to view this content.
    Drag all down
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-24-2020
    Location
    New Zealand
    MS-Off Ver
    2010
    Posts
    7

    Re: Return values in the first and subsequent non blank cells

    bebo021999 Thank you so much for your quick response. The functions you have supplied are absolutely perfect for what I needed. Thanks

+ 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] Return last 4 values in a Row, ignoring blank cells
    By UnitedCloud01 in forum Excel General
    Replies: 6
    Last Post: 07-24-2017, 01:12 AM
  2. Formula that returns only values of cells and doesnt return blank/NA values
    By pageandrewr1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2016, 12:32 PM
  3. [SOLVED] To get the Subsequent Cells Blank (Clear) for Each Change In the Drop Down Cell
    By tonisjoseph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2015, 01:52 AM
  4. [SOLVED] Easiest way to return a blank cell that can be used in subsequent calculations
    By GavJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2013, 01:15 AM
  5. [SOLVED] Look Up Values in row Table and return - subsequent row values
    By timharding in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2013, 10:45 AM
  6. Replies: 4
    Last Post: 03-15-2013, 01:03 PM
  7. Adding cells with values but if cells do not have values then return blank
    By jonnykhan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2012, 12:07 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