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.
|