You see on the left side... the [+] and [-] thing that toggles hide/show rows.
1. What is it called?
2. How do I make/set them up in excel?



[Edited on August 31, 2008 at 5:40 PM. Reason : .]

8/31/2008 5:38:51 PM

the feature is called "group and outline" its in the data menu.

basically just select a group of rows then press group or ungroup and it will make new levels. just experiment with it.

[Edited on August 31, 2008 at 8:50 PM. Reason : .]

8/31/2008 8:49:52 PM

I hate starting new threads every time an Excel issue comes up. There needs to be a perpetual thread.

So here's my issue:

I have a standard array formula which sums up the values in column E corresponding to the rows in which the value is C is the same as D55.
{=SUM((E$5:E$43)*($C$5:$C$43=$D55))}

The formula works fine when I manually enter values into column E. I can leave blanks and gaps in column E and the array formula still works.

However, the catch comes when I put equations into column E. I'm using some sort of IF statement where some cells return blank and some cells return values. =IF(A1exists,A1+B1,"") or something.
When that IF statement returns blanks "", the array formula above fails and returns #VALUE.
If I take the column of IF statements and manually delete the blanks but leave in the IF values (A1+B1), the array formula works. If I replace the blanks with zeroes in the IF statement [=IF(A1exists,A1+B1,0)] then the array formula works.
The only issue is when the IF statement returns blanks.

Weird.

9/2/2008 9:26:04 PM

yeah, i've had the same problem. Having a formula print "" does not store the same data, internally, as a blank cell. Or maybe the problem is that there is a formula in the cell, and even if it returns a blank, the formula itself still makes the cell non-blank

I would try to get it to work putting 0 or 1 or some other value in the cell. If you want the cell to appear blank, you can always use Conditional Formatting to reformat the cell to white

9/2/2008 9:57:00 PM

can you add if(isblank(X)) into the mix?

9/2/2008 10:26:02 PM