| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return a collum heading
Dear all,
How can my formulas return collum heading of specific current cell Thanks for help Bac |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return a collum heading
Assuming the activecell is B7, then
=OFFSET(B7,-ROW(B7)+1,0) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ABCBAC" wrote in message oups.com... Dear all, How can my formulas return collum heading of specific current cell Thanks for help Bac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Linear Mode
