How to Specify a range using another cell vale instead of row number
 

Hi Everybody,

Normally when we specify range in excel we specify as
$A$1:$A$1000, But I for my specific problem I need to specify range
using a vlue of a cell. i.e. $A$1:$A$B1, Where B1 can have a value
between 2to 1000, Is it possible, If so Pl. tell me in what method I
can do That.

Thanks and Regards

Ramana

How to Specify a range using another cell vale instead of rownumber
 

$A$1:INDEX(A:A,$B$1)

ramana wrote:
Hi Everybody,

Normally when we specify range in excel we specify as
$A$1:$A$1000, But I for my specific problem I need to specify range
using a vlue of a cell. i.e. $A$1:$A$B1, Where B1 can have a value
between 2to 1000, Is it possible, If so Pl. tell me in what method I
can do That.

Thanks and Regards

Ramana