Can I hide rows via formula only, no VBA?

[TAPS_MikeDion]

Hi Everybody,

Is there a (conditional format?) formula that can be used to hide a number of rows if there is a value in a cell? I'm unable to use VBA (VBA would be my preference, but long story short...it needs to be a formula.) I'm putting in a column called "HIDE" and what I was hoping to do is hide a set of rows when there is an X in the HIDE column.

Example:
There are hundreds of rows of data. However, if certain employees are not receiving a paycheck for the current pay period, but are still employed with company, I would like to simply hide the rows with that employees data. In the example below, I was hoping to do something to the effect (unless someone has a better suggestion) of putting an X in the HIDE column, and having Excel hide all rows below that, until it detects the next occurrence of an "X". This way, I merely put an X in the HIDE column to hide those rows or delete the X to show all of that employees data again.

In the example below, the result would be that with an X in rows 2 and 16, the rows 3 - 6, and rows 17 - 21 would be hidden.

Thank you VERY MUCH for any help given!

Book1
	A	B	C	D	E
1	HIDE	NAME	LOCATION	HOURS	TOTAL HRS
2	x	John
3			A
4			B
5			C
6	x				0
7		Lisa
8
9			A	80
10					80
11		Wendell
12
13			C	40
14			D	20
15					60
16	x	Samantha
17
18			A
19			C
20			D
21	x				0
22
Sheet1

Cell Formulas
Range	Formula
E6,E21	E6	=SUM(D3:D5)
E10	E10	=SUM(D9)
E15	E15	=SUM(D13:D14)

 

[Fluff]

A formula cannot hide rows. However if you put an X into every row that should be hidden, you could use the autofilter.

 

[TAPS_MikeDion]

Thanks Fluff. I tried that earlier and it worked okay, but my concern is that both of my bosses know almost nothing about Excel and have messed up things on me many times in the past once the workbook was in their hands. Having the filters would be just fine for me, but I can see the headaches coming if they start changing stuff. I guess I'll go with that for now and cross my fingers. LOL

 

[Fluff]

Glad to help & thanks for the feedback.