Extending Named Range

Hi Shreyas

Thanks for your question

Create a named range by going to Insert-Name-Define.

Give your ranage a name and in the refers to box type the following equation

=OFFSET($B$1,0,0,COUNTA($B:$B),1)

This uses the CountA function nested within the Offset function.The offset function specifies a start point of cell B1 and a finish point based on the number of populated cells in column B.

Hope this helps,

Regards

Stephen