Is it possible to link a cell value to a name range in Excel?

[Mark McInerney]

Hi All,

Is there a formula that if the last cell in a range is A6545, that it can return 6545 as a value in another cell.

Secondly, if that is possible, can I link that cell value, which in the above example would be 6545 to a named range. So, the range always starts from A1 and ends in A (whatever the value is the last cell in that range), which in the above example is 6545?

Any help appreciated - TY - Mark.

 

[Special-K99]

Last row number of cell in a column

=LOOKUP(2,1/(A1:A10000<>""),ROW(A1:A10000))

Dunno about the second question.

 

[Mark McInerney]

Hi Special,

Thanks for taking time to review - will try and let you know - Thanks again - Mark.

 

[SpillerBD]

If the Range is actually a Table, yes. Using the Array formula.

{=MAX(ROW(Table1))}

You can easily modify that to determine the cardinal coordinates of any Table.

 

[Scott T]

In name manager use.

=Sheet4!$A$1:INDEX(Sheet4!$A:$A,MATCH(1048577,Sheet4!$A:$A,1))

The named range will go from A1 to the last number in column A

 

[Mark McInerney]

TY Spiller - appreciated.