Replies

Legare,
The Set statement was a left over from my first try at the code.
It shouldn’t have been there.
Regards,
JimCone
San Francisco, CA

Legare,
The Set statement was a left over from my first try at the code.
It shouldn’t have been there.
Regards,
JimCone
San Francisco, CA

The following executes, but you will have to tell us if it is correct…
‘————————–
Sub Test()
Dim oCell As Double
Dim i As Long
For i = 22 To 48
Cells(1, i).Value = i + 18
oCell = Cells(1, i).Value
Cells(3, i).FormulaArray = _
“=SUM((LEFT(AccountList!B2:B5000,2)=” & oCell & “)*(AccountList!C2:C5000=””Dollars””)*(AccountList!R2:R5000>=2000)*AccountList!Q2:Q5000)”
Next ‘ i
Set oCell = Nothing
End Sub
‘——————————

Jim Cone
San Francisco, CA

The following executes, but you will have to tell us if it is correct…
‘————————–
Sub Test()
Dim oCell As Double
Dim i As Long
For i = 22 To 48
Cells(1, i).Value = i + 18
oCell = Cells(1, i).Value
Cells(3, i).FormulaArray = _
“=SUM((LEFT(AccountList!B2:B5000,2)=” & oCell & “)*(AccountList!C2:C5000=””Dollars””)*(AccountList!R2:R5000>=2000)*AccountList!Q2:Q5000)”
Next ‘ i
Set oCell = Nothing
End Sub
‘——————————

Jim Cone
San Francisco, CA

Hans,
Thanks, that seems to have cured it.
Regards,
Jim Cone
San Francisco, CA

Hans,
Thanks, that seems to have cured it.
Regards,
Jim Cone
San Francisco, CA

with your data in a column
select the data
right-click the fill handle at the bottom right corner of the selection
drag down for the number of periods you need
when you let up on the right button, a pop-up menu appears
choose “linear trend” or “growth trend”
be very skeptical

Jim Cone
San Francisco, CA

with your data in a column
select the data
right-click the fill handle at the bottom right corner of the selection
drag down for the number of periods you need
when you let up on the right button, a pop-up menu appears
choose “linear trend” or “growth trend”
be very skeptical

Jim Cone
San Francisco, CA

Hanan,

Microsoft already has a function “Convert” that does all the conversions you mention…
=CONVERT(1,”in”,”m”) returns 0.0254
=CONVERT(1000,”btu”,”wh”) returns 293.071851

The function is in the AnalysisTooPak, available by check marking it in Tools | Add-ins.

Regards,
Jim Cone
San Francisco, CA

Hanan,

Microsoft already has a function “Convert” that does all the conversions you mention…
=CONVERT(1,”in”,”m”) returns 0.0254
=CONVERT(1000,”btu”,”wh”) returns 293.071851

The function is in the AnalysisTooPak, available by check marking it in Tools | Add-ins.

Regards,
Jim Cone
San Francisco, CA

Ed,

For another opinion from someone who has written an Excel book or two…

http://j-walk.com/ss/excel/xl2003.htm%5B/url%5D

Regards,
Jim Cone
San Francisco, CA

Ed,

For another opinion from someone who has written an Excel book or two…

http://j-walk.com/ss/excel/xl2003.htm%5B/url%5D

Regards,
Jim Cone
San Francisco, CA

Steve,
I was in Bartlesville, Ok once a long time ago.

Take a look at the example sheet in the attachment.
It has a slightly different approach that some will like, others won’t.

Regards,
Jim Cone
San Francisco, CA

Steve,
I was in Bartlesville, Ok once a long time ago.

Take a look at the example sheet in the attachment.
It has a slightly different approach that some will like, others won’t.

Regards,
Jim Cone
San Francisco, CA

gg,

See the attachment for a primitive effort.
It was constructed by adding two dummy chart series.
I then added the data label using my “Chart Data Labels” add-in.

Jon Peltier is the uncontested Excel chart expert.
You can find out more than you ever wanted to know about customized charts at his web site…
http://www.geocities.com/jonpeltier/Excel/…ex.html#ArbGrid%5B/url%5D

My Chart Data Labels add-in is available free upon direct request.
Remove XXX from my email address.

Regards,
Jim Cone
San Francisco, CA
jim.coneXXX@rcn.comXXX