+ Reply to Thread
Results 1 to 4 of 4

Formula to find the last cell value in a column range that contains blank cells

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Formula to find the last cell value in a column range that contains blank cells

    I have a range of cells in a column (C4:C34) that contain some numbers and some blank cells. I have tried a few formulas, but none will return what I am looking for....the last populated cell value in the range.

    I am enclosing an example worksheet of what I am hoping to find. Thanks in advance for any help you can offer.
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Formula to find the last cell value in a column range that contains blank cells

    =lookup(9e+307, c:c)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-28-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Formula to find the last cell value in a column range that contains blank cells

    Thank you! I appreciate your help.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Formula to find the last cell value in a column range that contains blank cells

    You're welcome.

+ 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] Find first blank cell in first column of known range, select and delete from that point
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-09-2014, 09:41 AM
  2. 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
  3. Find blank cell, insert formula to find median of above cell range
    By lilyeye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 11:58 AM
  4. 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
  5. [SOLVED] Find first blank cell in single column named range
    By tig in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-09-2006, 01:40 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