Is there a formula to obtain a total for each quarter which excludes
including the year? Thus avoiding having to change to year on a yearly
basis. Your help would be appreciated.
First hit on web search:
quarter based on calendar year (with date in A2)
quarter based on FY starting in September, again w/date in A2:
> Is there a formula to obtain a total for each quarter whic...Rules Not Working
We recently switched to a web server email program - and my email now goes to
a different folder - not the personal folder inbox and I cannot get my rule
to forward e-mails to work - we have office 2007 - What's really confusing is
if I test the rule it will show the fwd arrow on the original message and a
copy will appear in my sent folder however the receipients do not receive it.
I am able to manually fwd the email with no problems.
I have a similar problem, however it had been working but I had to remove all
my accounts and reinstall them. My MSN account would not downl...All my icons look the same (except IE8 and the recycle bin)
i cant open any windows...when i click on them the open with window pops up
and wants me to pick wat i want to open it with...i can only get on the
internet in safe mode with networking. and when i try to open...for example
paint it says invalid bitmap, or its format is not currently supported and
other windows wont even open.
got any ideas on how i can fix this??
On Sun, 30 May 2010 06:54:01 -0700, xxkoreanxx wrote in message
> i cant open any windows...when i click on them the open with window pops up
> a...Pasting without updating cell references in formulas
I am a relatively low end user of Excel. I need to copy a large section of
formulas to create a new section of my spreadsheet. Excel does an excellent
job of changing all cell reference in the formulas based on the number of
cells that you cover in your copy and paste. HOWEVER, in this case I want
almost all cell references to remain the same. I can then edit each one and
change the one that I want changed. Is there any easy way to do this. I'm
sure there is.
Thanks in advance
As long as you are moving to the same sheet, just highlight the cells you
want to move and using mou...How can I show all field data in a pivot table, instead of blank
I want to perform lookups ona pivot table without using the gETPIVOTDATA
function. Is it possible to show a decsription against each line of the pivot
table, instead of blank spaces? e.g.
Field 1 Field 2 Data 1
Field 1 Field 2 Data 2
Field 1 Field 2 Data 3
Field 1 Field 2 Data 4
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. You could create a copy of the
pivot table, and fill the blanks, to do the lookup. Perhaps you could
use INDEX/MATCH formulas to work with the data in the pivot table, but
would have...Rules not working consistently
Ok, Outlook 2003.
I am getting a ton of junk mail for various ED medications (Viagra, etc.).
So I created a "rule" to delete any incoming message with "Viagra" in
But the rule works inconsistently. Most such messages do get deleted,
but not all of them. And I can't figure out why it's inconsistent.
There is nothing wrong with rule; if I go into the Junk Mail Folder, and
I "run rule now", it gets rid of those messages in the Junk Mail Folder
with Viagra in the subject. But why didn't it do that in the first
place? Why does it o...Calculating working hours to complete a task
i have a team who respond to customer requests, and they record when the
request came in and when it went out. I then report on how many working hours
they took to repsond, to see if within SLA or not.
To calculate this i use the following formula from Chip Pearson's website
(Sta...How do I get my CD into MS Publisher so I can work on the content
I jsut purchased MS Publisher 2003. How do I connect Publisher to my CD I
received and is in my CD drive.
What CD did you receive? Work on the content of what?...the CD? What's on
If you mean you have a Pub file on the CD, copy it to your hardrive, then
check the properties of the file to make sure it's not Read Only...if it is
change it. Then work on the file in Publisher
Just guessing here...if that's not what you mean please clarify.
"JoAnn @CCI" <JoAnn @CCI@discussions.microsoft.com> wrote in message
news:B742F41D-E267-437D-BEC4-25F54E46AA2C@...Email attachment not working
I'm getting a File Upload Error when I attach a file any bigger than 50 KB.
I know CRM must be able to handle this size. I read that it has a 5 MB
limit. I don't see anywhere anybody else having this problem. Please help.
is it a generall problem, that you couldn�t add any attachment?
If yes, you will have an IIS problem. Did you change anything at the IIS?
By default in Microsoft CRM, there is a 5 MB limit on attaching files to
You can increase this default by modifying the registry key
maxuploadfilesize located in the registry by navigating to
HKEY_...Office product key incorrect after reformat of computer
After reformatting my laptop which is running on the Vista OS, I reinstalled
microsoft office 2007 standard using the CD provided when I bought my laptop.
I could reinstall office 2007 however I am facing problems with activating
the product. Each time i keyed in the product key provided on the CD sleeve
of the office 2007 CD, i was notified that the product key is incorrect and i
have to key in the correct product key. I've tried several times and also
rebooted my laptop but to no avail. I have also made sure that I've read all
the digits and letters correctly. Is it pos...Copying Formulas to rows
I have created a book which has various formulas accross a row which
are all worked out from figures in that row.
But I cant figure how to make the whole sheet use these forumlas, i.e.
when i start typing info on row 2 it uses the same formulas as on row
The only way I have worked out so far to do this is to copy and paste
each row, but this is time consuming and im sure there must be a
Thanks in advance for your help.
mdj101's Profile: http://www.excelforum.com/member.php?a...Exchange 2003 Store Limit Warning does not work
Why does not the store limit warning work with Exchange 2003 ?
The "prohibit send" works ok, but the warning does not. How can I make it
work ? It would be very important to us.
On Wed, 10 Aug 2005 18:33:26 +0300, "Petri Paunonen"
>Why does not the store limit warning work with Exchange 2003 ?
>The "prohibit send" works ok, but the warning does not. How can I make it
>work ? It would be very important to us.
What doesnt work about it?
On Wed, 10 Aug 2005 18:33:26 +0300, "Petri Pauno...FORMULAS please help
I am trying to create a formula that refences <> numbers in a columm then
adds up the from a different columm
i.e add b1:b100 only if a1:a100 is >10000 <12000 =46
> Hi there
> I am trying to create a formula that refences <> numbers in a columm then
> adds up the from a different columm
> i.e add b1:b1...Looking for feedback
Hey everyone just started my own business doing consulting / training for Microsoft Outlook please check out my site www.outlookchallenged.com and provide any suggestions / feedback please. Any advice is good advice at this point.
Br Sense <firstname.lastname@example.org> wrote:
> Hey everyone just started my own business doing consulting / training
> for Microsoft Outlook please check out my site
> www.outlookchallenged.com and provide any suggestions / feedback
> please. Any advice is good advice at this point.
The best advice I have to offer ...Looking for CRM Solution
Does anyone use, or has anyone encountered, a CRM based solution used for
residentail, multifamily property management?
On Apr 28, 12:55=A0pm, MrB <M...@discussions.microsoft.com> wrote:
> Does anyone use, or has anyone encountered, a CRM based solution used for
> residentail, multifamily property management?
The beauty of Microsoft CRM is that it can be customized for any
business in any industry. It's ability to be customized using front-
end tools (not within code) is , as far as I know, unparalleled by any
other software package. You have the ability to create new entiti...Hyperlinks not working in email
I am suddenly unable to access hyperlinks in outlook 2002
email...the program tries to search for .exe files in my
documents instead of linking to the web site. Is there
some setting that needs to be reset?
higrenfell <email@example.com> wrote:
> I am suddenly unable to access hyperlinks in outlook 2002
> email...the program tries to search for .exe files in my
> documents instead of linking to the web site. Is there
> some setting that needs to be reset?
When it asks, browse to C:\Program Files\Internet Explorer amd click
iexplore.exe. That should ...Formula Help
I have a column of numbers (prices, i.e. 24.32)
I want to create a formula that does this (I want to create prices with a
If original number is between 0-4.99, then increase by 100% and go up to
If original number is between 5-9.99, then increase by 80% and go up to next
If original number is between 10-19.99, then increase by 50% and go up to
Once I have the basic formula then I can adjust it.
Can anyone help me solve?
Thanks in advance.
If you are going to have a few of these, then it would be better to
set up a l...=COUNTA() with multiple look-up
I would like to count the number of items that have a value "AAA" in
column A and an amount >0 in column B.
As I am not quite sure how to incorporate two look-ups in a counta
formula I was wondering if anyone can give me the formula?
Try something like this:
or....if there may be some text cells in B1:B100 interspersed with the numbers
Is that something you can work with?
&...Can't turn on Out of Office Assistant
Whenever I click on tool and out of office assistant, I
get the following message:
The command is not available. See program documentation
about how to use this extension.
How can I get my out of office assistant to work. I have
now spent 2 hours trying to figure this out.
This only works if you're connected to a Microsoft Exchange Server.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"Kim" <firstname.lastname@example.org> wrote in message
...Online Stock Trading and How the Stock Market Works #3
Here you can learn more about investing, and some specifics about
You'll also find a wide range of investing products and services to
help you plan toward financial independence - however you define it.
...can I edit a picture to look faded?
I want to edit my picture to be faded so I can use it as background with text
"deborahm" <email@example.com> wrote in message
> I want to edit my picture to be faded so I can use it as background with
> over it.
In Publisher you can do it one of two ways. For both ways start by
inserting the picture.
Method 1, right click on picture and select Format Picture, click on picture
tab, then click on the dropdown for Color under Image Control and select
wash...Fill & Line Colors...on Toolbar...Can't activate ?
I just installed Publisher 2003 and get Line & Fill Color buttons to activate
on my toolbar.
Anybody else having this problem on XP?
These tools will not activate if you don't have an object selected, either a text box
or some other element.
Is your graphics driver up to date?
Mary Sauer MS MVP
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote in
>I just installed Publisher 20...Scheduling desktop logoff
We have a new legal requirement to make sure system users logoff their
PC's daily (most just leave their user accounts signed in.)
Is there a way to have a group policy or script that will, say, call
Shutdown -l -f -t 5
(i.e. force a logoff of a user account on their domain member
workstation) at a given time each day? We would like to run this at
6:30PM each evening of the week.
Any ideas are appreciated.
You can add a aschedueldd task that contains the logoff or shutdown time
create a startup script like logoff.bat:
--------------...Change BackColor Code Not Working
I have a major request for the Dept of Justice. I have a report that looks
Task Type 4/5/2010 4/12/2010 4/19/2010
DSR St. Louis St. Louis
Exch RU Seatttle
Exch RU Memphis Memphis Memphis
What I need is code that will work. Basically if Task Type = DSR then the
background color of St. Louis and all other sites with "DSR" attached to it
should be Red. If the Task Type is Exch RU then it'll be Blue, etc.
Please respond quickly.
Your report looks good from here. I ...data look up and return values across a row
I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
to cross reference with another larger spreadsheet, which we'll call
'spreadsheet B'. I'd like to remove everything from B that isn't on A. Is
there an easy way of doing that?
Chip Pearson has lots of info about working with duplicates at:
> I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
> to cross reference with another larger spreadsheet, which we'll call