PDA

View Full Version : Solved: named ranges



Anomandaris
11-04-2009, 06:38 AM
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
11-04-2009, 07:53 AM
It depends upon what is in column A and what is in column C. If they are always 1-for-1, then no.

arkusM
11-04-2009, 08:12 AM
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
11-04-2009, 10:01 AM
Thanks for the info guys, that answers my question...