Solved: named ranges

[Anomandaris]

Hi,

Just a general query regarding named dynamic ranges.

In a sheet when there are several columns, and we are naming each column separately, is there any difference between the following formula?

=(Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$A:$A))

and

=(Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$C:$C))


assuming there are no empty cells


thanks

[Bob Phillips]

It depends upon what is in column A and what is in column C. If they are always 1-for-1, then no.

[arkusM]

Hi,

Just a general query regarding named dynamic ranges.
In a sheet when there are several columns, and we are naming each column separately, is there any difference between the following formula?
=(Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$A:$A))
and
=(Sheet1!$C$2:INDEX(Sheet1!$C:$C,COUNTA(Sheet1!$C:$C))
assuming there are no empty cells
thanks

If you are using the named ranges in an array formula I would suggest that you use a column that will always represent the most amount of rows to set the bottom of the range. If you don't if there are blank rows you named ranges will be different lengths and cause an error. I discovered the grief of differeing range lengths the hard way, as I used to use named range function like this a lot.

[Anomandaris]

Thanks for the info guys, that answers my question...