Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Extending Named Range
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Extending Named Range
Resolved · Low Priority · Version 2003
Reply
Extending Named Range
How do you extend a named range?For upcoming training course dates see: Pricing & availability
RE: Extending Named Range
Hi ShreyasThanks 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
Sun 31 Jan 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Resource management |
On the course we practiced scheduling up a meeting as a task, with the required attendees as resources. The meeting was scheduled for Friday afternoon. When one of the resources was given a non-working day (i.e. holiday, business trip, etc.), Project spli..
