Results 1 to 5 of 5

Find the third and fourth non-blank cells in a column and then enter each result in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2017
    Location
    Socal
    MS-Off Ver
    2013 excel
    Posts
    4

    Question Find the third and fourth non-blank cells in a column and then enter each result in a cell

    Hello All,
    I have been on numerous websites all day but have not been successful in finding the answer to my problem.

    Problem:
    I need help to find the third and fourth non-blank cell in a range in, see attachment.
    In range E12:E61, there are a series of blank and non-blank cells.
    I need a formula to find the third non-blank cell, which in this example is M5-M5 and then enter the result, M5-M5, in cell E2
    Similarly, I need a formula to find the fourth non-blank cell, which in this example is M7-M7 and then enter the result, M7-M7 in cell E4.
    Now all the cells in range E12:E61 have formulas in them so the third and fourth non-blank cell could change depending on other conditions.

    Any help would be appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to find the last cell value in a column range that contains blank cells
    By Bonzopookie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2014, 07:50 PM
  2. for the result i have enter 10 cell, plz find attachment
    By gsrikanth in forum Excel General
    Replies: 2
    Last Post: 05-09-2014, 07:04 AM
  3. Find & select 1st blank cell in a range of formulated column cells
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 09:26 AM
  4. Replies: 7
    Last Post: 08-14-2013, 05:41 AM
  5. Find the value of the 2nd to last cell in a column that includes blank cells
    By LookIWashed4Supper in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2013, 09:35 PM
  6. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM
  7. Macro formula to match two columns and Produce result in fourth column.
    By rishi1983 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2012, 08:50 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