|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content='"MSHTML 4.71.1712.3"' name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000>Augie, YOU WIN THE PRIZE.</FONT></DIV>
<DIV><FONT color=#000000></FONT> </DIV>
<DIV><FONT color=#000000>I made one minor change. I changed the part
,"<=4" to read instead "<=3.999999" though because it
was picking up the instances of both the number 3 and 4. Now it just picks
up the instances of the number 3.</FONT></DIV>
<DIV><FONT color=#000000></FONT> </DIV>
<DIV>Many thanks to all who responded.</DIV>
<DIV> </DIV>
<DIV>Bill N.</DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>AWong <<A
href="mailto:awong@xxxxxxxxxxxxx";>awong@xxxxxxxxxxxxx</A>><BR><B>To:
</B>metastock@xxxxxxxxxxxxx
<<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR><B>Date:
</B>Thursday, October 07, 1999 01:35 PM<BR><B>Subject: </B>Re: Excel
question. Help for the simple minded.<BR><BR></DIV></FONT>
<DIV>Bill,</DIV>
<DIV> </DIV>
<DIV>Please try this.</DIV>
<DIV> </DIV>
<DIV>=countif(A1:A10,"<=4")-countif(A1:A10,"<3")</DIV>
<DIV> </DIV>
<DIV>Augie</DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Oct 07 13:58:03 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id NAA19485
for <neal@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 13:46:00 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id DAA30095
for metastock-outgoing; Fri, 8 Oct 1999 03:57:13 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id DAA30092
for <metastock@xxxxxxxxxxxxxxxxxx>; Fri, 8 Oct 1999 03:57:10 -0600
Received: from hme0.mailrouter01.sprint.ca (hme0.mailrouter01.sprint.ca [207.107.250.16])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id NAA17502
for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 13:42:00 -0600 (MDT)
Received: from wlake (spc-isp-mtl-58-5-53.sprint.ca [149.99.140.53])
by hme0.mailrouter01.sprint.ca (8.8.8/8.8.8) with SMTP id PAA01573
for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 15:27:52 -0400 (EDT)
Message-ID: <001f01bf10fa$2930ddc0$358c6395@xxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <01bf10b2$1df9da80$b4742e9c@xxxxxxxxxxxxxxxxxx> <003f01bf10e6$02133940$5a9394cf@xxxxxxxxxxxxx> <003001bf10f1$717f63c0$c88c6395@xxxxx>
Subject: Re: Excel question. Help for the simple minded.
Date: Thu, 7 Oct 1999 15:28:39 -0400
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_001C_01BF10D8.A14E3220"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Sorry about that. Thanks for reminding me.
Download the .xla from Rob Bruce's site.
Go to Excel Tools --> Add-ins ---> Browse to download location
Install Add-in
Highlight Range or chart or user form etc.
Go to File (on main Excel menu) --> Export Selection as GIF --> Save to
folder
Write your email --> Insert --> File Attachment --> browse to folder with
stored Excel GIF
Bingo. We can all see your formulas, range, worksheet or chart etc. without
fear of viruses or having to worry about which version of Excel Metastockers
may have.
Best regards
Walter
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, October 07, 1999 2:26 PM
Subject: Re: Excel question. Help for the simple minded.
| For those Metastockers who want to post "pictures" of Excel ranges and
| worksheets to the List here is a download that will make it possible.
|
| GIF Exporter For Excel 97
| http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm
| "Enables charts and worksheet ranges to be exported as GIF files;
|
| Best regards
|
| Walter
|
|
| ----- Original Message -----
| From: AWong
| To: metastock@xxxxxxxxxxxxx
| Sent: Thursday, October 07, 1999 1:04 PM
| Subject: Re: Excel question. Help for the simple minded.
|
|
| Bill,
|
| Please try this.
|
| =countif(A1:A10,"<=4")-countif(A1:A10,"<3")
|
| Augie
|
Attachment Converted: "c:\eudora\attach\Losers.gif"
|