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
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