D
Doug
I can't use the formula below because this data links to
several different graphs and charts. If there are blanks,
it still shows in the graphs. Don't know anything about
macros. Can I still get help or is it to much to learn on
a message?
Thanks
Subject: Re: Formula to skip a cell
From: "Bernie Deitrick" <[email protected]> Sent:
10/9/2003 5:42:01 AM
Doug,
One possible solution is to change your formula to return
a blank if
the value is N/A:
=IF('Data input Sheet'!C11="N/A","",'Data input Sheet'!A11)
then use Data | Filter.... AutoFilter, and select Non-
Blanks on your
range with the formulas.
If that isn't satisfactory, then you would really need a
macro
solution and not a formula solution.
HTH,
Bernie
several different graphs and charts. If there are blanks,
it still shows in the graphs. Don't know anything about
macros. Can I still get help or is it to much to learn on
a message?
Thanks
Subject: Re: Formula to skip a cell
From: "Bernie Deitrick" <[email protected]> Sent:
10/9/2003 5:42:01 AM
Doug,
One possible solution is to change your formula to return
a blank if
the value is N/A:
=IF('Data input Sheet'!C11="N/A","",'Data input Sheet'!A11)
then use Data | Filter.... AutoFilter, and select Non-
Blanks on your
range with the formulas.
If that isn't satisfactory, then you would really need a
macro
solution and not a formula solution.
HTH,
Bernie