| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find next value in upper row?
I have a table with 5 columns and about 30 rows. A containes litres, B
kilometres, C average consumption in 100 km, D additive litres and E should have additives average consumption in 100 km. Problem is that additive is refueled in various periods and in between there might be 3-9 empty cells. I have also considered to add 1 column first on left which has dates, if this has any impact to formula-case. How do I make formula that finds next upper value and calculates total km between refilling additive? I have tried IF(ISBLANK(OFFSET... and IF(ISVALUE(FIND... IF(ISERROR(... but so far nothing works. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| Find Upper Case Text | Excel Discussion (Misc queries) | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
| How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
Threaded Mode
