I have a list of sales people in a worksheet and I only want the ones with
info in column c or column d to show up. If both are empty I don't want them
to show. Is there a formula that will hide the row if their is no data in
either of these cells?

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the ones with
info in column c or column d to show up. If both are empty I don't want
them
to show. Is there a formula that will hide the row if their is no data in
either of these cells?

Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the ones with
info in column c or column d to show up. If both are empty I don't want
them
to show. Is there a formula that will hide the row if their is no data in
either of these cells?

try it

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the ones
with
info in column c or column d to show up. If both are empty I don't
want
them
to show. Is there a formula that will hide the row if their is no data
in
either of these cells?

this is not what I'm looking for. I'm looking for no human intervension.

"Don Guillett" wrote:

try it

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the ones
with
info in column c or column d to show up. If both are empty I don't
want
them
to show. Is there a formula that will hide the row if their is no data
in
either of these cells?

Then a macro that would fire on activating the worksheet should do it for
you.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
this is not what I'm looking for. I'm looking for no human intervension.

"Don Guillett" wrote:

try it

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the
ones
with
info in column c or column d to show up. If both are empty I
don't
want
them
to show. Is there a formula that will hide the row if their is no
data
in
either of these cells?

Hi Brad

the only other alternative to Don's suggestion is to use code - which could
run automatically on the opening of the workbook or the selection of the
sheet. However, this does mean that the users have to have enabled macros
(and security settings need to be set to medium).

is this an approach you're interested in?

Cheers
JulieD

"Brad" wrote in message
...
this is not what I'm looking for. I'm looking for no human intervension.

"Don Guillett" wrote:

try it

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the
ones
with
info in column c or column d to show up. If both are empty I don't
want
them
to show. Is there a formula that will hide the row if their is no
data
in
either of these cells?