software

how would i clear info in fields once another field is selected quot;noquot;?

Manually?

I'd apply Data|Filter|autofilter to that field.

Filter to show the value you want.

Then select that visible range and edit|clear|contents

If you have multiple fields to check, you can apply the filter to the whole
range and use the filters to show just the rows you want to clear.

When you're done...use Data|filter|show all
(Or data|Filter|autofilter to remove the filter)
sunderland27 wrote:
gt;
gt; how would i clear info in fields once another field is selected quot;noquot;?

--

Dave Peterson

is there a formula that i could write that would allow my fields to be blank
once quot;noquot; is selected in the table?

quot;Dave Petersonquot; wrote:

gt; Manually?
gt;
gt; I'd apply Data|Filter|autofilter to that field.
gt;
gt; Filter to show the value you want.
gt;
gt; Then select that visible range and edit|clear|contents
gt;
gt; If you have multiple fields to check, you can apply the filter to the whole
gt; range and use the filters to show just the rows you want to clear.
gt;
gt; When you're done...use Data|filter|show all
gt; (Or data|Filter|autofilter to remove the filter)
gt;
gt;
gt;
gt; sunderland27 wrote:
gt; gt;
gt; gt; how would i clear info in fields once another field is selected quot;noquot;?
gt;
gt; --
gt;
gt; Dave Peterson
gt;


I've never used tables before but I think you could use the following
formula:

=IF(A1=quot;NOquot;,quot; quot;,A1)

A1 would be the cell in your table. If A1 is set as NO the cell your
formula is in will be blank. If A1 has any value other than NO the cell
with the formula in it will show the same value as the cell in your
table.

Hope this helps.

James--
JamesArchibald
------------------------------------------------------------------------
JamesArchibald's Profile: www.excelforum.com/member.php...oamp;userid=33284
View this thread: www.excelforum.com/showthread...hreadid=531632There's no formula that you can use to blank out the cells (like
edit|clear|contents).

But you could use a formula that displays different things depending on what's
in that cell:

=if($a2=quot;noquot;,quot;quot;,quot;Some other text or formula herequot;)

If you're just trying to give the impression that those cells are empty, you may
want to look at Format|condtional formatting.

You can format the cell with a white font on white fill (or same color on same
color).
sunderland27 wrote:
gt;
gt; is there a formula that i could write that would allow my fields to be blank
gt; once quot;noquot; is selected in the table?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Manually?
gt; gt;
gt; gt; I'd apply Data|Filter|autofilter to that field.
gt; gt;
gt; gt; Filter to show the value you want.
gt; gt;
gt; gt; Then select that visible range and edit|clear|contents
gt; gt;
gt; gt; If you have multiple fields to check, you can apply the filter to the whole
gt; gt; range and use the filters to show just the rows you want to clear.
gt; gt;
gt; gt; When you're done...use Data|filter|show all
gt; gt; (Or data|Filter|autofilter to remove the filter)
gt; gt;
gt; gt;
gt; gt;
gt; gt; sunderland27 wrote:
gt; gt; gt;
gt; gt; gt; how would i clear info in fields once another field is selected quot;noquot;?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson