Spreadsheet help!!!
I have a workbook with 2 worksheets.
Information and Table
in the worksheet Information, cell S24 if the number is greater than or
equal to $100,000 but less than $149,999 then I'd like it to put in cell
S25 the number $3000. Also if the number is between $150,000 to $199,999
i'd like it to put in $3500 in the S25 cell.
Any help would be highly appreciated...
Thanks
alex
--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4918
View this thread: http://www.excel...
Unable to add a new contact in CRM 4.0Hi all
Unable to add a new contact in CRM 4.0 as it errors out saying
"Object reference not set to an instance of an object".
Here is the event log information.
Web Service Plug-in failed in OrganizationId:
01f0210d-6bf6-4c27-8919-00eccab73e2d; SdkMessageProcessingStepId:
ab0fa3e5-3ceb-dc11-8840-0003ffbb159c; EntityName: contact; Stage: 50;
MessageName: Create; AssemblyName: AlertCRM40Plugin.CRM40PostPlugIn,
AlertCRM40Plugin, Version=1.0.0.0, Culture=en-US,
PublicKeyToken=4406fa73b5445f20; ClassName: AlertCRM40Plugin.CRM40PostPlugIn;
Exception: Unhandled Exception: System....
need help making chartI have a data table which im trying to produce a some charts from but
cant seem to get it right.
bit hard to explain without seeing the table so I have provided the
dummy workbook im working on at www.darkcity.nildram.co.uk/test.xls
in this example ive got the big data table, and the type of chart im
trying to produce form it us just below. the problem is ive had to
manually create another smaller table under the big one in order to get
the chart to look anything like what its meant to.
i really need to have 3 charts produced based on whats in the big table
if possible, I need charts by we...
Please help!!!!
I would like to know how to plot multiple sets of data on a scatter graph for
example i have 3 sets of data for three types of lighting systems, red, green
and blue i want to plot the voltage againt the current, and i want all the
data on one graph so i can compare them, how do i do it?
Frances
I suggest you try the following.
Plot a scatter graph as normal with your first set of data.
Then to add more data to the scatter graph...
Right click on chart and select <Source Data> and select the <Series> tab.
Select <Add> in the series dialog box and type in the relevan...
HELP! how to turn off synchronization log messages?!I have outlook XP on win2k, and my deleted items folder is being
filled by "synchronization log" messages at the rate of 1 per minute.
Where is a setting in outlook where I can disable/change that?
Thanks!
Rather than trying to turn off the symptom, perhaps you should look at the
logs to see what the problem is?
Aaron wrote:
> I have outlook XP on win2k, and my deleted items folder is being
> filled by "synchronization log" messages at the rate of 1 per minute.
>
> Where is a setting in outlook where I can disable/change that?
>
> Thanks!
There is...
HelpCRM 3.0 refuses to install on my SBS 2003 R2 premium server.
I was encountering the known issues with CRM 3 on SBS R2 using the CDs that
came in the Action Pack subscription so I downloaded the updated CRM CDs from
http://www.microsoft.com/downloads/details.aspx?FamilyID=7d418781-69ad-422d-92fa-87fdb2538e2c&DisplayLang=en
This copy gave me a different set of problems.
The default setup mode pops up a couple errors. The first one is the lack
of full text search so I installed that and ran the setup again. The next
error was:
"The edition 'Workgroup Edition' of the specified SQL...
Change Filter Rules of Default Global Address ListIs there any way to change the Filter Rules of the Default Global Address
List in Exchange 2003. The Modify button is greyed out. I want to hide
External Contacts from the GAL (by only displaying Exchange mailboxes or
mail enabled users), but still have those contacts appear under All
Contacts.
Any help would be greatly appreciated.
Greg
Greg:
You could do this by editing the Default Global Address List object in
ADSEdit. I think (if memory serves me correctly), the attribute that holds
the query is the purportedSearch attribute.
However, messing with attributes of default ...
Upgraded both of my macs to Office 2004 and wish I could have Office x back! Any help?!?!Hi,
I am running a G5 Imac 1.8Ghz and a G4 Powerbook 1.5GHz and have been
happily running office X on both machines for as long as I've owned
them (1 and 2 years respectively) Before the Pbook, I also had an I
book running Office X for 18 months with no troubles.
I just installed Office 2004 2 weeks ago, and am consistently noticing,
on both machines, serious system slowdown over the course of the day.
To the point where, by mid-afternooon, my system needs to be restarted.
The symptoms are identical on both macs (naturally the Pbook runs even
slower than the G5 as these problems advan...
in CRM Mobile, Can we assign / apply rules ?Both in CRM Mobile and Mobile Express, I didn't see any function about assign
/ apply rules / convert ...
These functions are not available out of box.
You can however, create workflow rules that "watches" for some changes to
field records so it can be triggered wheneven those fields are updated by CRM
Mobile or Mobile Express.
Frank Lee, Microsoft CRM MVP
Workopia, Inc.
http://microsoft-crm.spaces.live.com
"Goldensun" wrote:
> Both in CRM Mobile and Mobile Express, I didn't see any function about assign
> / apply rules / convert ...
...
How Does One Limit Outlook Help To Outlook?If I need to look something up related to Printer I don't want the help program to tell me how to
"Find and install printer drivers for Windows Vista" followed by "Find printer drivers for Windows
XP".
I entered Printer into Outlook help and the first ten results were:
Add or remove a printer
Change your default printer
Find and install printer drivers for Windows Vista
Find a printer manufacturer's Web site
Find printer drivers for Windows XP
Get the version number for your Office program and information about your computer
Change an ink or ton...
HELPWhen i'm on Outlook, how can i know which user account i use?
but when i start Microsoft CRM, i know which user i am because i must log in!
Could you tell me, what is the problem?
I wish you understand what i said
Thanks to reply
------=_NextPart_0001_42E90E06
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Hi and thanks for posting your question.
When you launch Outlook, it will use the credentials that you use to log on
to the computer. This will be a domain account, not a local machine
account. When Outlook is launched for the first time, it will create a
profile fo...
"Operation failed. Object could not be found." Outlook 2003, HELPMy Outlook 2003 testing on POP 3 indicates everything is okay. But when ever
I go to send or receive anything it always show the "Operation failed. Object
could not be found." Need help because Microsoft sure as heck doesn't have
any solution for this problem.
Thank you
You've provided no information that would permit anyone to answer.
State your how you configured your information store.
State whether Outlook ever worked for you and if so the steps you used to
corrupt your Outlook profile.
--
Russ Valentine
[MVP-Outlook]
"Bushie" <Bushie@discussions.mic...
Error 3045 on an MDE fileHi
I hope you can help me with this it is driving me nuts.
I've created a database which I needed to give multiple people access
to but didn't want them messing so I created an MDE file. I ensured
that the MDB file was set to shared, not compacting and set to run
users not owners permissions before I converted.
However, if one of the users goes into the database, it does not create
and LDB file and if anyone else tries to get it, the error message:
Could not use <name>; file already in use. (Error 3045)
appears. Some of the tables in the MDE files were linking to and MDB
fi...
Outlook 2000 error, helpI'm not real familiar with outlook, we use outlook express in our office
however new person wants to use "outlook" for email because he wants to
transfer the contacts he had from his old company. We have office 2000 here
and he can use outlook, that's fine. The problem is, I've imported his
contacts and now when I open the Outlook program I get the following error:
"A program is trying to access email addressess you have stored in outlook.
Do you want to allow this? If this is unexpected, it may be a virus and you
should choose no. Allow access for 1, 2, 5...
need help calculating intermediary valuesI'm not well enough versed in spreadsheet use to calculate some
intermediate values I need. I would be greatful for anyone who can offer
a formula or suggestion.
I have 1 guidline column, numbered 1-30. Then 2 other columns, A & B are
beside it. The values in A & B change as they go from 1-30, they change
at different rates. I have some intermediary values at given points but
need to calculate what the values in between would be, based on the
fixed values at 1, 4, 8, 15 and 30. Below, I have shown the layout as
best I can without including an attachment. Thanks.
chris@cjalexander...
Date Function HelpI need some assistance writing a formula that will count how many
dates (in a list of dates in m/d/y format) are in each month. So...
Column A [1/1/08, 2/7/08, 10/19/08, ...]
Column B [Months, Jan, Feb, Mar, ...]
Column C [Counts, {count of dates in January}, {count of dates in
February}, ...]
Make sense?
The obvious answer would be to use another column to extract the month
values and then just perform a COUNTIF function. But I can't use an
extra column.
Any help is appricated.
Thanks,
Shelton
Try this in C1:
=3DSUMPRODUCT(--(MONTH(A$1:A$100)=3DROW(A1)),--((A$1:A$100)<>"...
OT : Reading Help 2 Does anyone know of a free HTML Help 2
reader? Microsoft has completely redone
their docs, so that for most help topics it's
all or nothing: Install .Net and the entire
Windows SDK -- which comes with Help 2
files and the necessary reader software --
or get no docs at all.
That's about 1GB of stuff that I neither
want nor. (Since most of it is just .Net docs.)
I just want access to the latest versions
of things like WMI help that used to come
as independent downloads containing a
CHM file.
On Thu, 25 Mar 2010 15:25:00 GMT, mayayana wrote:
> Does anyone kno...
HELP: retreiving forgotten passwords from OutlookI've got Outlook 2003 and got a POP3 mail account set up. However I want to
do a fresh installation of Windows and will lose my account details. I do
not remember my password and was wondering how can I retreive my password
for the "Logon Information" and also "More Settings | Outgoing Server"
passwords. Since the passwords are in ****** format. I assume the passwords
are stored in Outlook files encrypted right?
KevinGPO, you wrote on Thu, 15 Dec 2005 09:20:48 -0000:
> I've got Outlook 2003 and got a POP3 mail account set up. However I want to
> d...
Sent e-mail disappear!!!!!!!!! Can you help . Reply (E-mail) Forward (E-mail)
Subject: Can anyone help with Outlook 2002 Problems
From: "robin hickey" <robin@e-s-p.eu.com> Sent:
3/3/2004 9:38:36 AM
Hi,
I have Office XP pro, which I upgrated to because my other
installation of 2000 still had the following problems...
When I send an e-mail it is received by whoever it is sent
to, and it appears in the outbox before it is sent, but
then just disapeers without being able to be found
anywhere?? Is this a virus?
Also, when creating my own letterheads for two different e-
mail accounts, but using one...
Link Cells (Read for more info) -- HELP PLEASEOk, this is for more advanced Excel users. Here's the issue.
Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
for a person, I want their name to automatically appear in COLUMN B from a
list in S2.
This is how S2's list is set up... A1 has a person's ID #, and B1 has that
same persons name. A2 has a different person's ID #, and B2 has that person's
name, etc... So when I type the ID # in S1 in column A, it will lookup in S2
and match that person's nam...
Making Changes Using Calendar WizardI have used one of the Calendar Templates and made changes to the initial
page. I then tried to do the "Change Date Range" to add more "months". The
only change that stayed was the new Logo I inserted using the Logo Options.
Colors and other editing was lost. Is there any way to get the subsequent
months to "take" the changes I made on the initial single January page?
Thanks!
Create all the months from the get go, open the color schemes taskbar, either
use one color scheme already defined or create your own. You will have to
manually add holidays and speci...
Help Needed: "IF" formula/logic too limitedI need to determine a value that is predicated upon the selections of about
6 or so drop down menus. It'd be General Text within drop-downs but final
value is an Accountant price
Basically if someone selects Option #1 out of Cells A-G's drop down menus,
then the value of H1 = a cell on another page that fits the category of 1-
1-1-1-1-1 from the drop down menus.
I don't know how to do this. I imagine it's possible but have no clue.
Your help is greatly appreciated.
From what you say, the meat of this problem lies in the layout/format of the
data you have in this "...
Help needed, pleaseI have a table which summarises customer visits to my office each week. A new
table is added each Friday, appearing immediately below the previous week's, in
columns A - H.
The columns are: (time) 8.30-10,10 TO 12,2-2.30,2.30-4.00,4-5.15,Total (visits
in the time slot),%;
The rows are for waiting time, and are in increments of 5 minutes
(1-5,6-10,11-15, etc) up to 60 minutes. The final row is the column totals.
What I need to be able to do is create a chart (or two, if necessary) which
shows an at-a-glance summary of busiest times of day and length of query, using
data collated from ALL ...
Rules work but have a delayI have a rule which whenever an email come into the Inbox, if the person is
in my address box to move the email to another folder.
The rule works ok but sometimes an email will come into the Inbox and sit
there for 30 seconds to 2 or 3 minutes before it moves to the other folder.
Clicking and Send/Receive has no effect.
Anyone know how to get rid of this delay?????
Thanks in advance
For those that might be able to help... What Version? What operating system?
Up to date?
"Copper" <noreplay@aol.com> wrote in message
news:uSP8pdAaHHA.1508@TK2MSFTNGP06.phx.gbl...
>I ha...
Rules and Junk MailIs there any way to include mail the program flags as junk
as part of a rule? I have two e-mail accounts that I
check, and I have a rule that moves anything coming in for
the second account into its own folder. The problem is
that it is moving ALL the mail to that address there,
including stuff that was already moved to Junk either via
my junk rule or via the program's junk filters. I want to
keep it in the trash where it belongs!
Toni
I had this problem - and figured out a solution.
1) Copy the Junk Mail rule. You cannot edit this rule,
but you can copy it.
2) Modify the rule ...