+ Reply to Thread
Results 1 to 5 of 5

Find last non-empty cell above in same column as current cell?

  1. #1
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    237

    Find last non-empty cell above in same column as current cell?

    I have a column that keeps a running total of crates (see pic below). I've tried various INDEX & INDIRECT formulas, but keep getting errors. I've figured out a formula that works great for other columns other than the current column, but what I need is to get the last non-empty cell above a certain cell?

    Any help would be greatly appreciated.

    YTD TOTAL.jpg

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,859

    Re: Find last non-empty cell above in same column as current cell?

    Assuming your

    Daily Net in A column & YTD Bal in B column

    B7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Check the attached file.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    237

    Re: Find last non-empty cell above in same column as current cell?

    Thank you so much! That worked perfectly.

    I tweaked it just a bit to account for blank cells:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    One question if I may.....What does the "15^15" portion of the formula do?

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,859

    Re: Find last non-empty cell above in same column as current cell?

    have a look below attachment for better understanding.

    https://answers.microsoft.com/en-us/...d-abf058a80165

  5. #5
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    237

    Re: Find last non-empty cell above in same column as current cell?

    Thanks so much for the reference. I do my best to understand the given solutions, so that I can rely less and less on you guys. Still, it's nice to know you guys are out there.

    Thanks again!

+ 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 empty cell in Column
    By thaykhov in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2014, 02:08 AM
  2. Replies: 5
    Last Post: 05-13-2014, 10:19 AM
  3. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  4. Replies: 12
    Last Post: 12-10-2013, 02:10 AM
  5. [SOLVED] Find next empty cell in column
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-12-2013, 04:26 PM
  6. Find first empty cell in column.
    By dlw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2012, 12:16 PM
  7. Replies: 1
    Last Post: 03-02-2010, 01:23 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