| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a formula that references the last value of a column
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Problems with external references when creating a drop down list | Excel Discussion (Misc queries) | |||
| Creating a formula that references other sheets | Excel Worksheet Functions | |||
Threaded Mode
