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

1. ## 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. ## 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:
`Please Login or Register  to view this content.`

Check the attached file.

3. ## 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:
`Please Login or Register  to view this content.`

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

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

have a look below attachment for better understanding.

5. ## 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!

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

#### 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