A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.59 seconds.
Search: Posts made by: Ken
Forum: Setting Up & Running Reports May 29th, 2010, 01:15 PM Posted to microsoft.public.access.reports
Replies: 0
Views: 436
Posted By Ken
output to pdf-select pages

i have a 3 page report in ms access. for one audience, the third page is not
needed, but for another audience it is needed. what is the best way to
accomplish this using the 3 page report...
Forum: General Discussion May 27th, 2010, 10:57 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 193
Posted By Ken
Pivot Chart Trendline?

Excel2003 ... when my Pivot Chart is Type "Column" ... I have ability to add
a "Trendline" ... However, when I change my Chart Type to a "Stacked Column"
.... "Trendline" is now grayed out???

So...
Forum: General Discussion May 27th, 2010, 10:37 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 104
Posted By Ken
green arrows in cells

Tools ... Options ... Error Checking Tab ... Remove the check marks as
necessary.

I only keep the 2nd & Last Boxes checked ... That's just me ...


--
Kha
Forum: General Discussion May 27th, 2010, 10:16 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 132
Posted By Ken
Pivot Table ... Stacked Col & Area Graph

Excel2003 ... I have a Pivot Table "Stacked Col" Chart reflecting operators &
the time they charged to a part ... Sometimes an operation is completed by 1
operator (sometimes multiple operators)...
Forum: General Discussion May 27th, 2010, 09:59 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 185
Posted By Ken
Delete an Add-In?

Gord ... (Hi)

I am still stuck ... Your method requires "Admin" rights ... :(

Ok ... I did find the file, but not sure I should delete it where I found it
(that's even if I can?) ... C:\Program...
Forum: General Discussion May 27th, 2010, 09:27 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 264
Posted By Ken
Veritical & Horizontal Lines only ... Graph?

Jon ... (Hi)

Yes ... I visited your sight ... & Yes ... I think a "Step Chart" is what I
am looking for.

Thanks for supporting these boards ... Much is learned here ... Kha

PS: Actually, I learn...
Forum: General Discussion May 27th, 2010, 09:18 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 264
Posted By Ken
Veritical & Horizontal Lines only ... Graph?

Eric ... (Hi)

I know nothing about Macros (I record only then perform creative cut/paste).
However, in reading your response I am thinking this is what I am lookin for
.... I will have to see if...
Forum: General Discussion May 24th, 2010, 09:25 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 185
Posted By Ken
Delete an Add-In?

Excel2003 ...

Tools ... Add-Ins ... Automation ...

I inadvertently selected one of these that I did not want ... Now how do I
remove it from my List of Available Add-Ins ... Thanks ... Kha

--
Kha
Forum: General Discussion May 24th, 2010, 08:37 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 107
Posted By Ken
Symbol = Character Code 25BA

Excel2003 ... Is there a way to "Conditional Format" based off of a specific
Character Code such as Symbol Character Code 25BA?

Thanks ... Kha

--
Kha
Forum: General Discussion May 21st, 2010, 07:39 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 81
Posted By Ken
Pivot Table Data Field ... )2

Excel2003 ... Pivot Table Data Field ... )2

In my Data Field I am seeing a Field = Field Name )2

What does the " )2 " mean?

I have the Field Name in my Data, but not ending in " )2 "

Thanks ......
Forum: General Discussion May 20th, 2010, 05:04 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 80
Posted By Ken
Sloooooow Scrolling?

Excel2003 ... I have 1 WorkSheet that Scrolls ever so slow ... Up/Down Scroll
will not move when you drag it ... the Screen Flickers in Stages & Scroll Bar
eventually moves ... This is killing me...
Forum: General Discussion May 20th, 2010, 04:01 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 264
Posted By Ken
Veritical & Horizontal Lines only ... Graph?

Excel2003 ... If I wish to create a Line Graph where the Line is Vertical &
Horz only between datapoints (no diagonal direction) for say 30 datapoints
.... How would I do this?

Actually, I would...
Forum: General Discussion May 19th, 2010, 09:08 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 144
Posted By Ken
Count Dates & Return as %

Per ... with a little gyration ... Did it ... Thanks ... Kha
--
Kha


"Per Jessen" wrote:

HI

In C275: =COUNTIF(C7:C272;"=" &TODAY())-C276
Forum: General Discussion May 19th, 2010, 04:20 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 144
Posted By Ken
Count Dates & Return as %

Excel2003 ...

Range C7:C272 contains Dates format = mm/dd/yy (& empty cells)

Looking for 3 Formulas for dates occuring as follows:

Cell C275 ... Count Dates __ Today () = -365
Cell C276 ... Count...
Forum: General Discussion May 5th, 2010, 03:39 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 90
Posted By Ken
Recognizing an Unstable Result

In Column "B" I have a list of results. Some of them have the result of
"#VALUE!".
I would like these cells to be represented in Column "C" with the result of
"0". What IF statement correctly...
Forum: General Discussion May 5th, 2010, 03:35 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 112
Posted By Ken
Time Stamp

I have a dynamic stock quote in cell "B2" ... in cell "C2" I want to record
the exact time that the stock price FIRST reachs a certain price. How do I
have this cell record this exact time only the...
Forum: General Discussion April 30th, 2010, 03:41 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 119
Posted By Ken
SUM ... Numbers, Nulls "", & Div/0

Jacob, Bob, Dave ... Thank you all for supporting these boards ... there are
many fine solutions found here ... Kha
--
Kha


"Dave Peterson" wrote:

=SUMIF(d3:d14,""&"#Div/0!")
or
Forum: General Discussion April 30th, 2010, 03:36 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 119
Posted By Ken
SUM ... Numbers, Nulls "", & Div/0

Jacob ... Simple solution (when you know it) ... Thanks ... Kha
--
Kha


"Jacob Skaria" wrote:

If the numbers are all positive numbers try
=SUMIF(D3:D15,"0")
Forum: General Discussion April 30th, 2010, 01:33 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 119
Posted By Ken
SUM ... Numbers, Nulls "", & Div/0

Excel2003 ...

Range (D3:D14) ... contains Numbers, Nulls "" & Div/0 ...

How do I write Formula to ... SUM the Numbers?

Thanks ... Kha

--
Kha
Forum: General Discussion April 30th, 2010, 01:18 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 167
Posted By Ken
Need "Div/0" Average Relief ...

Great suggestion ... Only I neglected to state that I have to do this for
every cell in the Range (D3:O14) ... I guess this just means more Helper
Cells ... Thanks ... Kha
--
Kha


"Luke M"...
Forum: General Discussion April 29th, 2010, 04:34 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 167
Posted By Ken
Need "Div/0" Average Relief ...

Ok ... I weaseled ... "Div/0" error still happens, but now not visible & does
not print.

1: I removed error checking piece from my Formula
2: I set Conditional Format of my Range...
Forum: General Discussion April 29th, 2010, 04:01 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 167
Posted By Ken
Need "Div/0" Average Relief ...

Excel2003 ... I do not usually work between WorkBooks ... I simply do not
like to ... :(

WB1 (Cell D3) ... AVERAGE Formula pulling from = 10 different WB's (Cell
D3) ... (Works great as long as...
Forum: General Discussion April 29th, 2010, 12:49 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 122
Posted By Ken
Excel2003 vs 2007 ... :(

OK ... Tell that to the IT Folks ... Thanks ... Kha
--
Kha


"trip_to_tokyo" wrote:

Kha, the only thing that I would say is NEVER do an upgrade until it has been
tested thoroughly and...
Forum: General Discussion April 28th, 2010, 02:04 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 135
Posted By Ken
Blanks ("") by Formula

I have it ... I just needed to remove the "A" & use COUNT ... I tried this
before with no success so I am guessing I fat-fingered something ...

My Thanks to all that provide the many helpful...
Forum: General Discussion April 28th, 2010, 01:55 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 135
Posted By Ken
Blanks ("") by Formula

Excel2003 ...

Range (H3:H13) contains Formulas returning a space ("")
Cell H15 contains ... =IF(OR(D1="",COUNTA(H3:H13)=0),"",SUM(H3:H13))

Cell H15 returning correct value when values in Range...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 06:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.