| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using last cell in a column that is not empty in a calculation
I'm using OpenOffice Calc 2.0. I don't know if that is the problem, but all
attempts I've made from other posts to do this results in #NAME or #VALUE?. My data: Col1 Col2 Jan 06 $300.00 Feb 06 $292.00 Mar 06 $330.00 Apr 06 EMPTY .. .. .. Dec 06 EMPTY YTD Difference Cell Col2:3 - Col2:1 How do I get Col2:3 and then next month, after I enter a value into April, Col2:4 - Col2:1? I hope this was clear. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| help locating first empty cell in a Column | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
