|
|
how do i open chap1_pe3_? by
bill64
I would like to know if someone could tell me how to open the
chap1_pe3_shortcuts document.I was given the task in class.The lesson is in
my exploring office...
|
February 15th, 2009 05:53 PM
by Paul
|
1 |
183 |
|
|
Line Chart by
Bob
I have the following data I want to chart:
8 12 16 36 64 100
Mtl Cost $15,207 $19,079 $22,950 $42,308 $69,408 $104,252
Engr...
|
February 15th, 2009 05:43 PM
by Paul
|
1 |
140 |
|
|
Average in Pivot Table by
Jeff
I have created a formula in a Pivot Table to average A,B and C.
I have tried the following with the same results:
=AVERAGE(A,B,C)
=Sum(A,B,C)/Count(A,B,C)
A ...
|
February 15th, 2009 05:03 PM
by Jeff
|
5 |
167 |
|
|
Multiple worksheets & duplicating formula by
Jackie
I have 35 worksheets; one w/s for each volunteer Each w/s has the exact
document to capture the number of hours a volunteers works and the type of
service...
|
|
7 |
249 |
|
|
Pivot table overwrites neighbouring cells by
Anissa
Hello,
I have multiple pivot tables on the same worksheet to allow for easy
comparison of data. The source data is based on the week and expected to be...
|
|
1 |
161 |
|
|
Formula for adding Columns by
Gary
Please help ...I'm going mad... How do I enter a formula to add colums
together?
Thanks in advance
|
|
7 |
225 |
|
|
Sorting gives odd results by
Lee
=SUMPRODUCT(--(CustomerNumberInvoice=Customers!$D3),--(WeekInvoice=$E$1),INVNET)
I am using the above to compare weekly customer sales of 2008 vs 2009. I
pull...
|
February 15th, 2009 02:28 AM
by Lee
|
5 |
188 |
|
|
Excel Pivot Table by
Jeff
Hi all,
I have a pivot table where I created a calculated field that averages three
of the fields in the pivot table. My problem is that it averages the...
|
February 14th, 2009 10:13 PM
by Jeff
|
4 |
156 |
|
|
excel 2002 data filter by
Ivanko
hello
this is the case
if i have in column A data like this:
http://www.abc.com
http://www.cba.com
http://www.abc.com
ok.
|
|
2 |
173 |
|
|
Pivot table overwrites neighbouring cells by
Anissa
Hello,
I have multiple pivot tables on the same sheet to allow for easy comparison
of data. The source data is a web query that is based on weekly data. As...
|
February 14th, 2009 03:15 AM
by Anissa
|
0 |
128 |
|
|
sumif results zero by
Michelle
Hi; I have an easy one that stumps me.
I have been using =sumif(b4:b63,"name",i4:i63) for many entries, and there
is one client name that keeps resulting in...
|
February 14th, 2009 02:41 AM
by Michelle
|
3 |
385 |
|
|
|
February 14th, 2009 01:34 AM
by Paul
|
1 |
157 |
|
|
How do I find Automotive maint. checklist? by
lost in the fog
I am using excel for the first time and do not know where to find things very
well, this is the first time I have used this source of information as well.
...
|
|
2 |
124 |
|
|
Gridlines by
aceman
I would like to make a template with the top 1/3 of the sheet blank and the
the rest with gridlines when I print the page.
How do I do this?
|
|
3 |
174 |
|
|
Absolute Values and Column Insertions by
BobK
I've created a formula in column A that adds up some cells in column D. Ex:
=sum(D3:D6). If I insert one column in front of column D, the formula changes
to...
|
|
4 |
229 |
|
|
Msgbox loop by
John
I am trying to establish a macro with a message box to loop through until the
Yes button is pressed. I am using Excel 2003. My code is below:
Sub Test()
Dim...
|
|
2 |
175 |
|
|
|
|
7 |
214 |
|
|
|
|
3 |
144 |
|
|
unwanted cell formatting by
cerfitz
every time I type a number containing a hyphen (03-8000) into a cell it is
automatically converted to date format even though the wporksheet is
formatted as...
|
February 13th, 2009 01:25 AM
by Max
|
1 |
200 |
|
|
test by
Cheyenne
test
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion,...
|
February 13th, 2009 12:50 AM
by Cheyenne
|
0 |
162 |