can a dynamic named range be built to capture non contiguous data? i actually want the range to be able to find certain records such that the named range contains all records that start with a "9", similar to a countif(range, "<9"). maybe there is an "includeif" function
)
i tried offset('FY11 Data'!B1,0,0,Countif('fY11 Data'!$A:$A,"<9"),counta('FY11 Data'!$1:$1))
but this gives me a range that is correct size wise ie has the right number of rows and columns. the problem is that unless the data is in ascending numeric order, the included rows will give a false read.
any ideas would be appreciated.
my task is to compare the YTD figures for this year to the same period last year. I will use the named range to identify the relevant transactions within the last year data for comparison against current ytd.
)i tried offset('FY11 Data'!B1,0,0,Countif('fY11 Data'!$A:$A,"<9"),counta('FY11 Data'!$1:$1))
but this gives me a range that is correct size wise ie has the right number of rows and columns. the problem is that unless the data is in ascending numeric order, the included rows will give a false read.
any ideas would be appreciated.
my task is to compare the YTD figures for this year to the same period last year. I will use the named range to identify the relevant transactions within the last year data for comparison against current ytd.
