• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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