Take number from cell above a gap

G

Guest

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

Always Display value in active cell cell x-rows above it ? 1
Date Ranges with Gaps - Finding Corresponding Maximum 0
Building a formula from another cell 3
Formula required 5
number to character and vice-versa 8
Format a cell based on incremental numbers 3
Populate one cell with an offset cells contents 2
Printing Only Rows With Values In Them 2

Top