[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel question. Help for the simple minded.



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//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">
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Bill,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Please try this.</DIV>
<DIV>&nbsp;</DIV>
<DIV>=countif(A1:A10,"&lt;=4")-countif(A1:A10,"&lt;3")</DIV>
<DIV>&nbsp;</DIV>
<DIV>Augie</DIV></BODY></HTML>
</x-html>From ???@??? Thu Oct 07 11:18:09 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 LAA15885
	for <neal@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 11:12:12 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id BAA28562
	for metastock-outgoing; Fri, 8 Oct 1999 01:34:26 -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 BAA28559
	for <metastock@xxxxxxxxxxxxxxxxxx>; Fri, 8 Oct 1999 01:34:24 -0600
Received: from mail.ptd.net (mail1.ha-net.ptd.net [207.44.96.65])
	by freeze.metastock.com (8.8.5/8.8.5) with SMTP id LAA17410
	for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 11:19:12 -0600 (MDT)
Received: (qmail 24198 invoked from network); 7 Oct 1999 17:04:34 -0000
Received: from dr025009.cable-dr.mah.ptd.net (HELO jzilaiti.ptdprolog.net) (24.229.25.9)
  by mail.ptd.net with SMTP; 7 Oct 1999 17:04:34 -0000
From: "joe zilaitis" <jzilaiti@xxxxxxx>
To: "metastock" <metastock@xxxxxxxxxxxxx>
Subject: Version 7.0 Pro
Date: Thu, 7 Oct 1999 13:04:29 -0400
Message-ID: <01bf10e6$0461bd20$0101010a@xxxxxxxxxxxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00DD_01BF10C4.7D501D20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content="text/html; charset=x-user-defined" http-equiv=Content-Type>
<META content='"MSHTML 4.71.1712.3"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 face=Arial size=2>Well, here it is. 
</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Thu Oct 07 12:18:07 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 MAA17744
	for <neal@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 12:17:27 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id CAA29125
	for metastock-outgoing; Fri, 8 Oct 1999 02:54:45 -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 CAA29122
	for <metastock@xxxxxxxxxxxxxxxxxx>; Fri, 8 Oct 1999 02:54:42 -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 MAA17445
	for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 12:39:34 -0600 (MDT)
Received: from wlake (spc-isp-mtl-58-5-200.sprint.ca [149.99.140.200])
	by hme0.mailrouter01.sprint.ca (8.8.8/8.8.8) with SMTP id OAA17090
	for <metastock@xxxxxxxxxxxxx>; Thu, 7 Oct 1999 14:25:28 -0400 (EDT)
Message-ID: <003001bf10f1$717f63c0$c88c6395@xxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <01bf10b2$1df9da80$b4742e9c@xxxxxxxxxxxxxxxxxx> <003f01bf10e6$02133940$5a9394cf@xxxxxxxxxxxxx>
Subject: Re: Excel question.  Help for the simple minded.
Date: Thu, 7 Oct 1999 14:26:14 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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:   

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