Refer upper field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Info - 08 Oct 2007 04:45 GMT

Is there any function that can refer upper or beside field without defining
specify field?For example,i'm select row A1,then i use Alt+G to select blank
field,then the blank field will refer the value/text each of there upper
field,example field A2 refer A1,A3 refer A2,A4 refer A3 and so on........

Thanks for your knowlendge.

Reply to this Message

Darren Bartrup - 08 Oct 2007 13:59 GMT

Have you tried looking at INDIRECT and ADDRESS functions.

=INDIRECT(ADDRESS(-1,0,4,FALSE),FALSE)
This will look at the cell 1 row up (the -1) in the same column (the 0)
where the formula is placed.

Helpfile states for ADDRESS function:
Creates a cell address as text, given specified row and column numbers.

INDIRECT simply turns it into a real cell reference.

> Is there any function that can refer upper or beside field without defining
> specify field?For example,i'm select row A1,then i use Alt+G to select blank
> field,then the blank field will refer the value/text each of there upper
> field,example field A2 refer A1,A3 refer A2,A4 refer A3 and so on........
>
> Thanks for your knowlendge.

Reply to this Message