View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default 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.