If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic range based on another column
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 (Column H) that will have a value for every cell within that column. The column that needs updates (Column O) has blanks and it is those blanks that will possibly have information in the data dump. I was thinking if I could give it a dynamic range name then I could look, find and enter the data for the blank cells. But I am stuck on how to write the dynamic range to equate to the same number of cells from Column H for Column O. There are several columns that I will be applying this to but all being the same length as column H. Can anyone assist? -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Dynamic range based on another column
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 Carrie_Loos via OfficeKB.com wrote: 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 (Column H) that will have a value for every cell within that column. The column that needs updates (Column O) has blanks and it is those blanks that will possibly have information in the data dump. I was thinking if I could give it a dynamic range name then I could look, find and enter the data for the blank cells. But I am stuck on how to write the dynamic range to equate to the same number of cells from Column H for Column O. There are several columns that I will be applying this to but all being the same length as column H. Can anyone assist? |
#3
|
|||
|
|||
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 | |
Display Modes | |
|
|