| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cant get dynamic range formula to work.
Biff,
Forgive me for my blunder. I copied the formula in a partially modified state. It should be: =INDEX(P:P,LARGE(IF($P$7:$P$65535<"",ROW($P$7:$P$ 65535)),ROW($AM$17)-ROW())) I've got it working now. Thanks, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array formula with a dynamic range. | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Setting dynamic range in a formula | Excel Worksheet Functions | |||
| Help to adapt Formula syntax to work with Dynamic Named Ranges | Excel Worksheet Functions | |||
| formula to set up dynamic range in names | Excel Worksheet Functions | |||
Hybrid Mode
