Ignoring a row of data
- From: Turnipboy <Turnipboy.22i7tm_1138719300.4567@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 08:54:03 -0600
I have column of data in the form:
x y
1 6
4 3
6 0
I have plotted x vs y and also calculated the average of y. How can I
easily ignore a row of data, without deleting it, so that it does not
appear in the graphs AND is no longer taken into account when finding
the average of the y column - i.e. AVERAGE(B2:B4). HIDE does not seem
to satisfy the last condition.
--
Turnipboy
------------------------------------------------------------------------
Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24527
View this thread: http://www.excelforum.com/showthread.php?threadid=506768
.
- Follow-Ups:
- Re: Ignoring a row of data
- From: Bob Phillips
- Re: Ignoring a row of data
- Prev by Date: Re: Calling on a macro within a macro!
- Next by Date: Re: Calling on a macro within a macro!
- Previous by thread: help urgent
- Next by thread: Re: Ignoring a row of data
- Index(es):
Relevant Pages
|
