How do I set up a daily average of unit sales formula
More info required.
(remove nothere from the email address if mailing direct)
"jim m" <jim firstname.lastname@example.org> wrote in message
...Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <email@example.com> wrote in message news:ED708...Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...Using scanner in Word97
I want to scan a picture into word97 using my HP 4370 ScanJet. Could not
find option of "From Scanner" under "Insert" --> "Picture". Apparently I
must need some sort of Word97 Add-On. What and where is the add-on? Is it
on the Office97 CD? Same applys to Excel97.
Also, does microsoft sponsor a Word97 / Office97 discussion group? If so,
would appreciate a link.
"PSRumbagh" <PSRumbagh@discussions.microsoft.com> said this in news item
> I want to scan a picture ...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
news:DA9FFF99-FC28-...Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this:
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?
Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for
any and all empty cells in A2 to A9. It no longer matters if any of the
cells are empty, the formula correctly gives the correct addition of A1
plust a sum of everything between A2 to A10 without any #VALUE! results.
Was hoping to have the formula above als...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Forumla to calculate a percentage
I have a column of figures that I need to calculate that if the figure in
column A is Transport costs to us is �100 and column B is the price sold to
the customer is �25.00, i need the third column to work out < 72%
Theoretical Transport Recovery
in other words if the value in column B is <72% mark it red
Like wise for fuel is the value in column B is <132% mark it red
Try as I might I cannot get it to work it out
This formula gives the correct percentage...
Format the formula cell with this custom number format...
If you don'...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <email@example.com> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Using Publisher 200 with Publisher 2003
How do I covert PUB2000 documents to Pub2003 documents and vice versa?
Pub 2003 can open anything, no conversion necessary. Going backward is a bit
trickier. File - Save As and chance the file type to a Pub 2000 file.
Possible problems can arise if you've used a feature that was not available
in the 2000 version and your file size will grew immensely.
MVP Microsoft [Publisher]
"nasuco" <firstname.lastname@example.org> wrote in message
> How do I covert PUB2000 documents to Pub2003 do...Calculating on alphabetic cell content
A selection of 4 different letters in a column representing different values
to be used in a formula shall be run through. The calculated result of each
cell in the column shall be placed in the cell next to the read one that
holds the letter.
Thanks in advance.
i think you're after the COUNTIF function
with your column of letters in A1:A100
and the letter you're interested in in C1
then in D1
this will count the number of times the value in C1 occurs in your range.
If this isn't what you're after, could you type out a few examples of your
...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
=SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...Formula to display nearest following Thursday in mm/dd/yyyy format
I have been reading and trying different suggestions here to no avail. What
I need is a formula to calculate the nearest following thursday, and display
it in mm/dd/yyyy format.
To be clear, I have a column of varying dates. I need a formula to return
the next thursday for each of those dates.
To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010 in
cells A1 through A4. In cells B1 through B4, I would like to see 05/27/2010,
05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.
Thank you for your help!
T...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Calculating the 95% confidence inteval of a slope
As a low key user, I can calcualte the slope of a line from the x and y
values, but I don't know how to determine how good the estimate is. Can
1) Using Analysis ToolPac Regression tool. See
2) With LINEST and/or STEYX. See
quote:The STEYX function calculates the standard error of a regression, a
measure of the amount of error accrued in predicting a y for each given x.
Th...Find Highest Score In List Formula
I'm looking to return the highest score for a users with multiple
scores in a list of other users with multiple scores.
Say the data is like:
and we want the max score for frank:
I have a formula, bt4/37 (bt4 = 6) and it returns 5. However, my calculator
and an Access database returns 16. Can someone tell me why Excel returns 5?
Either I'm reading this post incorrectly or you have a broken calculator and
are gettting results out of excel & access that are equally incorrect.
6/37= 0.162 recurring
So if we assume that your result of 16 is a typo and you meant .16 there
must be something your not telling us about the formula your using in Excel.
How is the 6 derived in BT4 ?
What is the format of BT4 ?
Post the pr...