Formula help! #2
can someone help me where i have a row of numbers that go
0, 0, 0, 0, 0, 5, 10, 5 etc... from cells D2:K2
i want a formula to put in A2 that returns the first non-
zero number, ie. it would return 5. it would also be
useful to have a formula that returns which column the
first non-zero number occurs in.
any ideas? thanks
First non-zero (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
where rng is your range reference (e.g., D2:K2).
Column the first-non-zero occurs in (also array-entered):
=LEFT(ADDRESS(1,3+MA...sales Configurator and sales forecast
I am trying to use the sales Configurator in Great Plains in
conjunction with the sales forecast. The problem I am running in to is
the items in the forecast are the items that make up the configured
item, therefore, the item doesn=92t show as a line item on the Sales
Order, therefore, not deducted from the sales forecast.
I know it's a lot said in one sentence.
Forecast item A for 5, B for 3 and C for 2 all in the month of June.
Then a sales order for a configured item (Config) has a due date in
June calling out A qty 1 and C qty 1.
The forecast QTYs for June should be A for 4, B for ...Update Rollup 1
Attempting to install this update rollup on CRM 3.0 Server, Windows 2003
Server, SQL 2000 SP4:
CRM 3.0 (KB922815) Installation Error
Setup failed to update the database. The installation of this update has
stopped. Contact Customer Support Services.
Any thoughts or suggestions appreciated.
> Attempting to install this update rollup on CRM 3.0 Server, Windows 2003
> Server, SQL 2000 SP4:
> CRM 3.0 (KB922815) Installation Error
> Setup failed to update the database. The installation of this update has
> stopped. Contact Customer...I cant open links in MS outlook.
Help! I cannot access any links in MS oulook. Everytime I try to open a
link, it pops up and wants me to tell it what program to run it with.
I have a hyperlink set-up for a netwrok file. It works fine, but when the
file is copied the hyperlin chages to the folder that the file has been
original link - L:\folder\folder\file
Changes to - C:\file
How can I get it to keep the original link?
In the interest of saving a little time and getting it right does anybody
have a sales process template already built that executes the stages of the
solution selling process?
If so you can you email it to me at:
crm at (go away spammers) ibizinitiatives.com
Or is it posted someplace on the partner site or int tech support someplace
that I haven't found yet?
ibizinitiatives. (spammers go away) com
You can download a tool from Microsoft that allows you to export and import
workflow processes between crm serve...Outlook & Word XP: How do I print labels for Christmas cards?!
I get some incredibly frustrated with MS Word & Outlook sometimes!
Especially when it comes to trying and make it print a bunch of labels for
me, for addressing Christmas cards. According to the online help I can
start in Outlook's Contacts and select those I want to send messages to.
Fine. I've done that.
Now what?! The instructions don't say, and I just can't lay my head on the
keyboard and hope to learn what I'm supposed to do next. I suppose the
online help could help, but I don't know what the "correct" key words would
be, so I cannot enter the k...Symantec WinFax Pro outlook 2003
Problem description Thank you for submitting an error report. The error was
likely caused by: Symantec WinFax Pro Solution Symantec WinFax Pro was
created by Symantec� Corporation. Symantec� Corporation informed Microsoft
that they have a solution available for the problem you reported. To learn
more about the solution, Symantec� Corporation recommends that you visit the
Is this a part of outlook 2003 cause I don't remember installing it or is
this the fax program with XP Pro. Don't really know what cause outlook 2003
to hang but when I reported the error this is ...Frequent "Error must shutdown"
My Publisher 2003 has been giving me an error message and restarting for
months now. Sometimes I can work for 30 minutes, sometimes it shuts down
after only a couple of minutes. It seems to happen when I complete a
project, and go to the next one. I send the error reports requested,
thinking at some point a fix will be made available. I'm not seeing any post
addressing this issue. Is this something unique to my system? I have
reinstalled Pub with no results. I'm running XP Home SP2.
Have you installed the updates for your 2003
Office Programs? If you go to the following
...Short Sale of Options
I'm trying out Money Plus Deluxe (trial version). I can't update my
investment account because it's hungup on option transactions.
I download info from my investment account and I have an option short sale
(sell to open). So I now have this list of transactions to enter into Money,
and it hits the short option which is listed something like "CHK Sep 45
Call". It tells me that this item already exists, asks if I want to choose
another from the pull-down list above, but the pull-down is grayed out. Then
I notice an extra space after "CHK", so I delete one ...outlook #111
To whom it may concern,
When I go into my outlook express and into my inbox the
last email sent is opened and takes the whole page. I
want all my messages displayed and unopened. Help.
<firstname.lastname@example.org> wrote in message
> To whom it may concern,
> When I go into my outlook express and into my inbox the
> last email sent is opened and takes the whole page. I
> want all my messages displayed and unopened. Help.
Firstly, please do not post to a technical group using just the name of the
software as your subj...Report builder 2.0 create report incident based
I would like to make a report of the cases which are made and how much time
we spended at the specific case.
I add the incidentbase and the incidentresolutinbase in the reportbuilder
but the items are unrelated. There must be an incidentid in the both bases
but he is only in the incidentbase. Can someone explain how solve the
Or do I have to select other tables?
I hope someone can help
You should not be writing reports against the base tables - use the Filtered
views instead. They are easier to use and will respect the CRM security
of the user running the report...Outlook Template Problem
This is a multi-part message in MIME format.
I have a document that I want to save as a template to use over and over =
I have read the instructions found here: =
http://office.microsoft.com/en-us/assistance/HP051892651033.aspx but I =
cannot do this part...
1.. In the Save as type box, click Document Template. This file type =
will already be selected if you are saving a file that you created as a =
Is this something that come...DATABASES #2
I am trying to create a worksheet that has multiple tabs. Each tab needs to
have a database that uses information located on that sheet. However, I can
not get Excel to let me enter a database on the second sheet. It keeps
wanting to go look at the first sheet's formulas. How can I create a
database for each sheet in my workbook?
Your suggestions were wonderful. I have thus far added 7 extra sheets and
gotton all of the formulas to work.
Thank you so much for the help.
> I am trying to create a worksheet that has multiple tabs....Outlook 2007 Settings
I recently got a new laptop with Office 2007 on it. When setting up
Outlook I copied all of the settings verbatim from Outlook 2003 on my
old system. When I'm in the office I don't have any trouble, it works
perfectly. When I'm out of the office I can't connect at all. We have
a VPN, but I'm told that the new computer has been granted access on
the servers (I don't have access to the servers). We're running
Exchange 2003. Any ideas on what I need to change in order for my
email to work all of the time? If my post is better suited to a
different group plea...Error 3014 when trying to open reporting tab
Hello, I've been away sick for a few weeks and on my return, the 3x DPM
servers I have here all have the same error. When you try to open the
Reporting Tab in the DPM console your presented with the following error.
"An error occurred causing the reporting job on
NLMSBK3.NP1.NEC-Philips.local to fail. The system files may be corrupt.
Retry the reporting task. If the problem persists, repair your DPM
installation using the steps described in the DPM 2007 Deployment Guide.
I've tried to check a few things, everything looks normal, nobody is owning ...removing outlook express
i dont need this and dont want it.
how do i get rid of it.
I am not sure about the current version, but in previous
versions, Outlook used Outlook Express. When using that
previous version (don't recall which) removing Outlook
Express goofed up my Outlook.
>i dont need this and dont want it.
>how do i get rid of it.
Don't remove it.
Just delete the shortcut icons to it so that you don't see any evidence of
its existence unless you know where to look. It only consumes about 4MB, and
chances are there are lots more ...Outlook Express Error Messages
When I try to open outlook express I get two messages:
1)Outlook Express could not be started. The application
was unable to open the Outlook Express message store. Your
computer may be out of memory...
2)Outlook Express could not be started because MSOE.DLL
could not be initialized. Outlook Express may not be
I have WindowsMe and outlook version 6.0.
...Error in Formatting
I have Excel 97 Pro on Win98SE.
I had almost forgot it but has happened about three minutes ago.
Sometimes, any kind of cell formatting causes following error:
EXCEL caused an invalid page fault in
module MSO97.DLL at 017f:307333ca.
EAX=02c4000c CS=017f EIP=307333ca EFLGS=00010207
EBX=00002080 SS=0187 ESP=0062d0f8 EBP=0062d428
ECX=00005dd5 DS=0187 ESI=00630000 FS=59f7
EDX=0001a606 ES=0187 EDI=02c42ebc GS=0000
Bytes at CS:EIP:
f3 a5 8b ca 83 e1 03 f3 a4 5f 5e c3 8d 14 0e 3b
02c4000c 0062d150 30001065 02c4000c 006...how do I create a macro of text in Outlook 2003?
I need to insert a short sentence in many of my emails in the subject line.
I tried looking into creating a Macro via the Outlook Help instructions, but
I don't know how to write code. It seems that 2007 has quickstarts for this
purpose, but can anyone tell me how to do it in Outlook 2003?
the term is QuickParts
> I need to insert a short sentence in many of my emails in the subject line.
> I tried looking into creating a Macro via the Outlook Help instructions, but
> I don...how can I find and download a WAB DLL file for Outlook 2000
When trying to use outlook I get a error message "cannot find WAB DLL" I may
have accidently removed it.
What OS are you using? Curious since OL2000 isn't Vista compatible.
"JEJE" <JEJE@discussions.microsoft.com> wrote in message
> When trying to use outlook I get a error message "cannot find WAB DLL" I
> have accidently removed it.
if you are using vista, see http://www.outlook-tips.net/howto/vista_wab.htm
otherwise, we need to know the version of windows.
Diane Po...Exchanging items (return and sale in one transaction)
Is is possible to return and sell an item in the same transaction? For
example, a customer wants to return clothing in one size and get the same
item in another size. There is no price difference. Is there any problem
with recalling the original transaction for return and then scanning the
right size item in that same transaction?
Also, is it possible to return one or more item and simultaneously buy one
or more items with different prices/total costs?
RMS Help file doesn't have information on this.
Bikes...Outlook Page Breaks
Is there a way to get Outlook to allow page breaks within
a message that has been sent to you.
Sean <email@example.com> wrote:
> Is there a way to get Outlook to allow page breaks within
> a message that has been sent to you.
Page breaks have no meaning in an Email messages. There are no "pages" to
(Unless you're attaching a Word document or something similar where pages
are meaningful constructs.)
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace....outlook 2007 send mail error
Trying to send mail and getting error
Sending' reported error (0x8DE00006) : 'The operation failed
I'm running office 2007 with office outlook connector
I've removed the account and recreated it in outlook 2007 as well as
repaired the outlook connector same error .
Anyone know why and how to solve >?
"me" <firstname.lastname@example.org> wrote in message
> Trying to send mail and getting error
> Sending' reported error (0x8DE00006) : 'The operation failed
> I'm running of...Outlook 2003 Send/Receive
Currently using SBS 2003 with win xp pro clients, also
using office 2003 pro.
The problem is the junk e-mail filter only works in
cached mode. When Outlook is running in cached mode, it
will send messages immediately but receive immediately
and only if you select the send/receive button. Then if
you tell it to perform the send/receive function every 1
minute, but also to send messages immmediately it only
does the send/receive feature every 1 minute. If you
create a new message it sits in the outbox until you wait
1 minute or hit the send/recieve button.
I need outlook to run i...