I've setup a range in my financial statement and the description I put in was a group description eg Other employee benefits. So when the statement is expanded I get multiple lines saying other employee benefits, instead of pension, health etc.. I'd prefer to see the account description for each one when expanded. How can I do that? I know how to get the account description if it wasn't in a range, but how do I do it when I want the range to be called something that isn't part of an account description?

Hi Barb:

That's a good question because it shows you understand the benefit of using ranges. In the cell where you currently have the description, enter the following:

=GLDESC("Other employee benefits",3,$Bxx)

Where:
-The 2nd parameter (in this case 3) is the number of spaces that you want to indent the description
-The 3rd parameter points to the cell containing the range of GL accounts - replace xx with the row number (for instance $B12 on row 12)

When you expand the sheet, the individual account descriptions will appear.

I'm learning. Thanks for the help.