| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Named Ranges
Thank you for your assistance.
"Peo Sjoblom" wrote: Assuming it's the same column =LOOKUP(2,1/(A1:A65535<""),A1:A65535) since you just want the last value there is no need to refer to the offset formula, replace A with the column in question -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "SJT" wrote in message ... I am using the OFFSET formula to create a dynamic named range that is several rows long and several columns wide. How would I create a cell reference in another spreadsheet that dynamically refers to the last cell of that range. Thank you in advance for your assitance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum Wizard with dynamic named ranges | Excel Worksheet Functions | |||
| Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
| Problem with Dynamic Named Ranges | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Hybrid Mode
