Percent increase in excel #2
How could I do a percent increase when I have two tables with money values,
one from last year and one from this year?
A1: <last year's value>
B1: <this year's value>
Format C1 as a percentage.
In article <29182E64-291B-4B10-804E-88FE105D24AB@microsoft.com>,
"Aiko" <Aiko@discussions.microsoft.com> wrote:
> How could I do a percent increase when I have two tables with money values,
> one from last year and one from this year?
Thank you for your answer, I send you and e-mail because I came up with new
pro...Outlook quitting immediately after opening #2
Outlook quitting immediately after opening
Outlook quits straight after it opens.
I have removed it and re-installed it but its made nodifference.
I get a half second view of the inbox (which is still my original inbox
which seems strange after removal and reinstallation?)
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
...synchronize 2 exchange 2003 servers
How can i sync. 2 exchange servers ?
Is this possible with InterOrg ? (i want also sync the GAL)
Since these are 2003 servers, you need to sync AD's, really. I don't think
that the old InterOrg product will work for you, but MIIS might.
"mel" <firstname.lastname@example.org> wrote in message
> Hello all,
> How can i sync. 2 exchange servers ?
> Is this possible with InterOrg ? (i want also...Merging Labels #2
Hello, I'm back with the same question. How do you get labels to merge from
a database on one sheet? Not individual names on one sheet each?
The instructions I have received so far does not work:
1. Under setup page size, create a blank page that is the size of one label.
2. Under Page Setup, select the option "Change Copies per Sheet", Click on
"Multiple Copies Per Sheet".
I still get multiple labels on one sheet with one name????
>Hello, I'm back with the same question. How do you get
labels to merge from
>a database...How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
...Change Default View #2
Is it possible to determine a user's business unit and set the account entity
default view depending on the business unit? I know it is not standard, I
You may be able to use a plug-in on the SavedQuery RetriveMultiple event.
Here is an example to hide system views :-
This is just a starting point to give you an example. You would have to
check if the query being passed is to return the default view, and if so
overr...2 questions from a beginner
Hi i have 2 questions on how to do things if anyone could help it woul
be great. I need to create a text box and a button where when you ente
a number in the text and click the button it mutiplies the number, th
question actually looks like this... a) Define a variable Mult in you
b) When the user clicks the button if the textbox has an empty string
set the variable Mult to 10. If it is not empty, set the variable Mul
to the number they typed into the textbox.
c) Use a for..next loop to fill in the values in column A and B a
shown in the sample. Hint use the cell property.
and the othe...What's wrong in this formula???? #2
I don't really understand:
I have several 'ElseIf' conditions, for 3 it should be multiplied b
100, for 4 by 125 etc. So i have precise amounts to calculate
according to the number of hours (2,3,4,5 or over).
I don't see how can a MAX or MIN determination be the solution.
Could you please clarify this?
Ekser's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1140
View this thread: http://www.excelforum.com/showthread.php?threadid=27484
Did you try it?
...CRM 1.2...What kinds of language is available ???
I heard CRM 1.2 is availbale in 9 languages....
but don't know what languages are included....
so please, let me know what languages are included!!!
Here you go:
San Francisco, CA
>> Other Microsoft CRM Online Forum Resources:
>I heard CRM 1.2 is availbale in 9 languages....
>but don't know what languages are included....
>so please, let me know...Advice on Exchange 2003 Recovery #2
I have spent the last 6 hours going over the MS docs on Exchange 2k3
recovery, but none seem to address this situation I have.
1 Seattle office
1 New York office
Both have a domain controller serving a single domain.
The single Exchange 2003 server is in the Seattle location.
Disaster Recovery Scenario:
Seattle is Nuked
Somehow I and my colleagues survive. We go to our disaster recovery
facility in Portland, OR and install a fresh copy of Windows on new
hardware, VPN to New York, and add the new server as a second DC to the
New York DC.
My question is how am I to recover exchange?
I have...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
I am working from a very large word document, approximately 1000 pages
long. Each page has one 'article' on it.
I am currently doing something manually, which I would love to do
using a macro.
I am populating a table (which happens to be in an Excel spreadsheet)
One column is the Article number 'xxxxx'. One of the other columns is
a 'Topic' which is typically three alphanumeric characters (like AA1,
AD4, BB4 DO6 etc.)
This is what i have to do
Step 1 - Jump to the page with the article number. Achieved by
p...Contacts with multiple email addresses #2
When I right-click a contact and click create new
message, all of the contacts three email addresses
autimatically appear in the "to" line. How do I prevent
this from happening. In other words, how do I make one
the three addresses for that contact a default address so
that only that one appears when I try to send an email.
...Print Preview using CPreviewDC
I have a problem trying to implement a print preview
function. Yet the printing itself is no problem.
I have this chart control with a method
which outputs the data to the CDC object.
Now I want to do Print Preview similarly using the
CPreviewDC class mentioned in the MSDN Documentation
instead of the CDC class.
How do I setup the CPreviewDC object without a print
And after I have printed the content into the CDC class
how do I display the print preview?
...Renaming Organization #2
Is there a documented procedure of renaming the exchange organization and
site name of Exchange 2003? Is it even possible?
On Sat, 10 Dec 2005 11:50:02 -0800, "TagaR"
>Is there a documented procedure of renaming the exchange organization and
>site name of Exchange 2003? Is it even possible?
You really don't want to try and go near changing the org name. That
way lies stress.
There is no such thing as a "site" in E2K3 but you can change the name
of the Administration Group i...Set Print Preview to always show color
It was easy enough to get Publisher 2003 to perform a print preview in black
and white using Tools, Commercial Printing Tools. I want to set it back to
print preview in color but it refuses to do so. I have jacked around with
all of the radio buttons for Any Color, Single color, Process Colors, etc.
but nothing seems to work.
If anyone can help me out, please do so.
How about the printer settings? Are they set to color? The Generic Color Postscript
for Commercial Printing has a color choice in the preferences. Paper/Quality tab.
Have you checked the printer pre...About IVR #2
I want to develop an IVR system. I have found two
options for developing the same. One is the use of TAPI
and another is the use of Visual C++ and MFC. Which is the
best alternative? I want to develop such a system that it
should have minimum installation problem. Difficult
programming is not an important matter for me.
...Print Receivables Schedule Payments
How can I print the invoice (as in Transaction>>Sales>>TRansaction Entry) of
an individual Schedule Payment in Receivables Management?
I dont want to print the entire Schedule Invoice used, just a specific
invoice (Tools>>Routines>>Sales>>Posted Schedule"
Go to Inquiry>Sales>Transaction by Document or Transaction by
Customer. You'll find the invoices in this inquiry window. Highlight
the invoice you want print and click on the Document Number link to
open the Receivables Transaction. You can print the invoice from
Frank Hamelly...COUNT IF x 2
I'm using the following formula to count the number of occurences in a list
=COUNTIF('Full Output'!K:K,"*Outlook Edition*")
I however need to check another argument in that 'Full Output'!C:C must =
I would therefore like to say COUNTIF('Full Output'!K:K,"*Outlook Edition*"
AND 'Full Output'!C:C, "Sales")) but can't seem to check for both.
Thanks very much for your help,
COUNTIF will only work for one criteria.
Use SUMPRODUCT instead:
=SUMPRODUCT(('Full Output...Not Print Zero values
I need to do one of two things:
1) My zero values are hidden but they span down 300 cloumns. Is there
away to hide these from printing?
2) The zero values above are a simple currency total between tw
fields. I have filled the incrementing formulas down about 300 rows. I
there a way to fill in the next incrementing formula [(b2)*(d2)] whe
the calulation is made? I want to keep from having 300 growin
formulas, I'd rather try to have them incrimentaly auto fill so m
print outs wont have 20 extra blank pages.
----------------------------------------------...Print areas #2
Is there any way of getting excel to determine print areas depending on
I have a spreadsheet whose print area needs to change for different
data entered and I want to be able to automatically set a print area so
the user doesn't need to fiddle with the print area manually.
Thanks in advance,
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
If you do not create a print_area then Excel will print the entire active
range. If that's not good e...deleted folder #2
I accidentally deleted a saved folder in outlook express, can I get it back,
I had saved personal messages.
This newsgroup is for support of Outlook 97, 98, 2000, 2002 & 2003 from the
Office family for Intel PCs. For Outlook Express (OE) support try posting in
one of these newsgroups:
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.windows.inetexplorer.ie5.outlookexpress&SLCID=US&sd=GN&id=fh;en-us;new...Task status problem #2
I will explain my problem step by step:
1- I create a task and assign it to somebody.
2- He receives the task and accepts it.
3- He completes the task
4- I receive an e-mail saying that the task I assigned is
5- Despite the email I receive, the task starus does not
change when I check the Tasks folder?
I would really appreciate it if anyone can help, because
all the tasks in the office are messed up at the moment.
We cant keep track of anything.
How long do you wait? It can take about 2 minutes. Does the task update
arrive as plain text or RTF format? If it's...Corporate Name Change #2
How does one change the name of a stock (and symbol) when
a company (such as AOL) decides to do so
...Converting money file #2
I have installed GnuCash. Can I use Microsoft Money data with it?
Microsoft MVP - Money
For unofficial FAQs see
I do not respond to any emails that I have not specifically asked for.
"abc" <email@example.com> wrote in message
>I have installed GnuCash. Can I use Microsoft Money data with it?
GnuCash imports QIF. Money exports QIF. Assuming GnuCash does sane things
with the iimports, that'd be better than nothi...