| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Take number from cell above a gap
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take number from cell above a gap
Try
=C15-LOOKUP(9.99999999999999E+307,C$1:C14) "GB" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
Hybrid Mode
