+ Reply to Thread
Results 1 to 12 of 12

Return last populated cell from column to the left until next populated cell occurs

Hybrid View

  1. 01-23-2017, 10:17 AM #1
    abx
    abx is offline
    Registered User
    Join Date
    07-30-2007
    Location
    United Kingdom
    Posts
    8

    Re: Return last populated cell from column to the left until next populated cell occurs

    Quote Originally Posted by Tony Valko View Post
    Try this...

    Data Range
    K
    L
    1
    2
    47455
    47455
    3
    47455
    4
    47455
    5
    47455
    6
    47455
    7
    47466
    47466
    8
    47466
    9
    47468
    47468
    10
    47471
    47471


    This formula entered in L2 and copied down:

    =LOOKUP(1E100,K$1:K2)
    This solution also works nicely. Rep added to both answers and thread marked as Solved. Thank you all.
    Reply With QuoteRegister To Reply
  2. 01-23-2017, 11:04 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return last populated cell from column to the left until next populated cell occurs

    You're welcome. Thanks for the feedback!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I don't want dates to be automatically populated until the cell is populated
    By SBC004 in forum Excel General
    Replies: 3
    Last Post: 09-30-2016, 10:48 AM
  2. Is it possible for 1 cell to total 1 column if populated, but if not to add up other cells
    By clairebear32 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-11-2013, 10:56 AM
  3. How Do I Remove The Carriage Return Symbol From Cell Populated By A UserForm TextBox?
    By stuu3270 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-12-2013, 11:31 AM
  4. How to keep cell blank till cell to left is populated?
    By SVTF in forum Excel General
    Replies: 2
    Last Post: 01-09-2011, 01:24 PM
  5. Excel 2007 : How to match dates on two worksheets to return value in populated cell
    By colins in forum Excel General
    Replies: 8
    Last Post: 02-10-2010, 05:34 PM
  6. Finding the last populated cell in a column array
    By JosephJames in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-18-2009, 12:42 PM
  7. Value of last populated cell in column
    By eintracht in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 04:19 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1