EXCEL LEVEL FILTER

[Guest]

I HAVE A TABLE THAT HAS A STRUCTURE AS MOTHER-CHILD LIS

-
-
-
-- C
-- C
2
-
-
I WOULD LIKE TO ADD A FILTER TO ROWS TO HIDE CHILD LEVEL(C1,C2) BELOW OF C, OR 1ST CHILD LEVEL(A,B,C) BELOW OF 1 ETC.
I THINK THERE IS A WAY FOR THIS
ANY HELP?

 

[Tom Ogilvy]

Look in Data=>Group and Outline. You need to group and outline your data
and then you can do this.

--
Regards,
Tom Ogilvy

I HAVE A TABLE THAT HAS A STRUCTURE AS MOTHER-CHILD LIST
1
-A
-B
-C
-- C1
-- C2
2
-A
-B
I WOULD LIKE TO ADD A FILTER TO ROWS TO HIDE CHILD LEVEL(C1,C2) BELOW OF

C, OR 1ST CHILD LEVEL(A,B,C) BELOW OF 1 ETC..