<div>
Keep your named range as is (i.e. $E:$E) and try using the following formula for custom ranges.<br />
Assuming that TEST is the name of you range, <br />
For the list of data that starts from row 10<br />

<pre><code id="code-20-36487351-1">=OFFSET(TEST,9,0,COUNT(TEST)-9,1)</code></pre>
<br />
For the list of data that starts from row 2<br />

<pre><code id="code-20-36487351-2">=OFFSET(TEST,1,0,COUNT(TEST)-1,1)</code></pre>
</div>


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)


For the list of data that starts from row 2


=OFFSET(TEST,1,0,COUNT(TEST)-1,1)

<div>
<div class="content wysiwyg-content">
Hello, <br />
i want to select rows of specific column with custom row as the start range.<br />
<br />
My Named Range so far is :<br />
=Category!$E:$E<br />
<br />
but i want exclude the first row, i tried =Category!E2:$E but doesn't work ?<br />
Also, in some sheet i want to select the data that starts from row 10 (till the end of row in a column) ?<br />
<br />
Thanks
</div>
</div>


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

Microsoft Excel : Named Range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.