| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Dynamic range based on another column
Thanks!
Roger Govier wrote: Hi InsertNameDefine Name RngO Refers to =$O$1:INDEX($O:$O,COUNTA($H:$H)) or Name lrow Refers to =COUNTA($H:$H) Name RngO Refers to $O$1:INDEX($O:$O,lrow) For more information take a look at a tutorial I wrote at http://www.contextures.com/xlNames03.html -- Regards Roger Govier I have a worksheet with several columns that I intend to update daily from a data dump. I am trying to set up a dynamic range based on a previous column [quoted text clipped - 8 lines] Can anyone assist? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query Refresh Based on Dynamic Named Range | Excel Discussion (Misc queries) | |||
| Any way to have a dynamic range for ranking, based on criteria? | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| dynamic summed range based on a variable | Excel Worksheet Functions | |||
| overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
Threaded Mode
