| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Assignment of a Cell Address In Formula
Well, at least we have overcome the first obstacle ... since the
formula now seems to work ... As you requested it, the formula is intended to return the Last cell address thanks to the MAX() function ... It could be that using <=K6 creates some illogical pattern with your data ... My initial recommendation for you is to test the formula without <=K6 ... but with =K6 to fully master the formula, and determine if you are reaching your objective. Should you still face difficulties, feel free to send me your spreadsheet ... HTH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Dynamic Cell Address As Formula Location | Excel Worksheet Functions | |||
| Dynamic Formula with Dynamic Address | Excel Worksheet Functions | |||
| Average Function and dynamic cell address | Excel Worksheet Functions | |||
| Dynamic flexible cell address | Excel Discussion (Misc queries) | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
