Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer upper field
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer upper field
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. "Info" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) |