| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a formula how can I reference the outline level of a row?
I would like to create a column that automatically calculates an outline
number of a row in a spreadsheet based on its level of indenture when rows are grouped and ungrouped in Outline mode. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a formula how can I reference the outline level of a row?
Select A1. Create a named variable, like "level" -- Insert/Name/Define, type
Level. In the Refers to, use =GET.CELL(28,A1) In the worksheet, enter =level and it will return the row level. For column, use GET.CELL(29,A1) "Dana DeLuca" wrote: I would like to create a column that automatically calculates an outline number of a row in a spreadsheet based on its level of indenture when rows are grouped and ungrouped in Outline mode. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How to Define a named Formula at the Worksheet level? | Excel Worksheet Functions | |||
| stop showing changed text in formula bar on different level | Excel Discussion (Misc queries) | |||
| outline | Excel Worksheet Functions | |||
| another EXPERT LEVEL FORMULA from me | Excel Discussion (Misc queries) | |||
Hybrid Mode
