| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a formula that references the last value of a column
See replies at your other post.
Biff "conny" wrote in message ... Hey, I was wondering if there was any way to create a formula that references the last cell with a value in a column. This excel worksheet we have is updated with a new value for the 2007 column every week, therefore we are just copy and pasting our simple formulas one cell down each week. I was wondering if there was any way to set a formula up that would just take the last cell that has an entry in it and then start our formulas with that reference point. If you need further clarification, just write back. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula that references the last value of a column | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| creating cell references | Excel Discussion (Misc queries) | |||
| How do I change column references when filling down a formula | Excel Discussion (Misc queries) | |||
| Creating a formula that references other sheets | Excel Worksheet Functions | |||
Hybrid Mode
