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 » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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 06:53 PM
by Paul Go to last post
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 06:43 PM
by Paul Go to last post
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 06:03 PM
by Jeff Go to last post
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...
February 15th, 2009 05:41 PM
by CurlyDave Go to last post
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...
February 15th, 2009 04:55 AM
by Shane Devenshire[_3_] Go to last post
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
February 15th, 2009 04:31 AM
by Shane Devenshire[_3_] Go to last post
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 03:28 AM
by Lee Go to last post
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 11:13 PM
by Jeff Go to last post
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.
February 14th, 2009 05:12 PM
by Gord Dibben Go to last post
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 04:15 AM
by Anissa Go to last post
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 03:41 AM
by Michelle Go to last post
3 385
Copying from one TAB to another based on certain criteria by Thomas
Hi all, I'm curious if it's possible to copy data from one TAB into another based on certain criteria. For example: if you have a spreadsheet with...
February 14th, 2009 02:34 AM
by Paul Go to last post
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. ...
February 14th, 2009 02:00 AM
by Gord Dibben Go to last post
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?
February 14th, 2009 01:57 AM
by Gord Dibben Go to last post
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...
February 13th, 2009 09:03 PM
by Niek Otten Go to last post
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...
February 13th, 2009 04:57 PM
by Chip Pearson Go to last post
2 175
Need a excel formula which can see the second moving by wilchong via OfficeKB.com
Dear sir, I set an excel formula =NOW() which show the time. However, the time will only refresh when I hit the formula. My question is that is there...
February 13th, 2009 02:08 PM
by CurlyDave Go to last post
7 214
Excell spread sheet: reinstate number of rows to 50 by Monica
In my excell spread sheet, I need to find out how to reinstate a specific number of rows. It is an address spread sheet with approx 40-50 rows. As it stands...
February 13th, 2009 05:33 AM
by Shane Devenshire[_3_] Go to last post
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 02:25 AM
by Max Go to last post
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 01:50 AM
by Cheyenne Go to last post
0 162
Post New Thread


Display Options
Showing threads 2121 to 2140 of 13737
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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