• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Microsoft Excel : Named Range

Hello,
i want to select rows of specific column with custom row as the start range.

My Named Range so far is :
=Category!$E:$E

but i want exclude the first row, i tried =Category!E2:$E but doesn't work ?
Also, in some sheet i want to select the data that starts from row 10 (till the end of row in a column) ?

Thanks
0
veematics
Asked:
veematics
2 Solutions
 
Rory ArchibaldCommented:
If you specify a start cell, you must specify an end cell too:

=Category!$E$2:$E$65536 for example.

Or for a more dynamic range:
=Category!$E$2:INDEX(Category!$E:$E,COUNTA(Category!$E:$E))
0
 
UnattendedCommented:
Instead of
$E:$E
try
E2:E65536
0
 
SANTABABYCommented:
Keep your named range as is (i.e. $E:$E) and try using the following formula for custom ranges.
Assuming that TEST is the name of you range,
For the list of data that starts from row 10
=OFFSET(TEST,9,0,COUNT(TEST)-9,1)

Open in new window


For the list of data that starts from row 2
=OFFSET(TEST,1,0,COUNT(TEST)-1,1)

Open in new window

0
 
veematicsAuthor Commented:
Thanks for the help
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now