Take number from cell above a gap

G

GB

Does anyone know a function to take the number from the first cell above a
gap of cells. What I've got: a date column, depth column, elevation column,
change column. Not every date has a corresponding depth/elevation/change.
I've got it set up now that the change in elevation column takes the current
elevation and subracts it from the previous elevation. The current equation
is just C15-C14. If there is a gap in the data, say 9 days, how can I get
Excel to automatically take C15-(whatever the next cell with data in it above
C15)? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Need Help with a VBA subroutine 0
Payment calculation 1
Line-Column 2 axes Help 1
Problem with formula for finding last greater than/less than or equal to value 2
Goal Seek with variable Set Cell 1
Building a formula from another cell 3
Changing the value in a cell (but a bit more complex than that <G>) 3

Top