JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have a named range: "Campaign" in N2 with capaign names in O4:O10
I also have a named range: "Campaign_List" =OFFSET(Campaign,2,1,COUNTA(Settings!$O:$O)-1)
How can I replace Settings!$O:$O to something relative to Campaign? This is to be used for Data validation as a list formula.
I then wish to create the same _List name for another 2 column table where Cells(2, x) is a named range, so in effect:
"Count number of non blank cells in column 1 right of named range"
TIA,
Jack
I have a named range: "Campaign" in N2 with capaign names in O4:O10
I also have a named range: "Campaign_List" =OFFSET(Campaign,2,1,COUNTA(Settings!$O:$O)-1)
How can I replace Settings!$O:$O to something relative to Campaign? This is to be used for Data validation as a list formula.
I then wish to create the same _List name for another 2 column table where Cells(2, x) is a named range, so in effect:
"Count number of non blank cells in column 1 right of named range"
TIA,
Jack