Help with formulas
I am trying to create a table whereby all companies are given a
rating/position according to the points scored, against a set of
criteria given - ratings of which can be anything between one and ten.
Ten being the highest.
The maximum score is obviously 80 (eight categories)
The rating put in will be manual but I need a formula that will
calculate the amount and then look at the highest score and then
provide a position number. i.e scores given to individual companies
so what I want the formula to do is give a 1 for 80, 2, for 64, 3 for
46, 4 for 23 and 5 for 10.
I ...Pivot percentages urgent help please
how do i consolidate percentges in a pivot table
Gross Margin $3500
Gross Magin % 35 %
Either your clock is wrong or you are trying to stay at the top of the
questions. I delete these.
"Kumar" <Kumar_p50@hotmail.com> wrote in message
> how do i consolidate percentges in a pivot table
> Actual YTD
> Gross Margin $3500
> Gross Magin % 35 %
> pls help
I created a form in Outlook using the Tools/Forms/Design a
form, and I saved some and published others and now I am
receiving all my FacSys faxes in that form instead of my
regular message form!? I'm not sure how this happened but
PLEASE HELP!!!!!!!! How do I revert back to the default on
the format for receiving my faxes??? HELP!! :)
Shanda <email@example.com> wrote:
> I created a form in Outlook using the Tools/Forms/Design a
> form, and I saved some and published others and now I am
> receiving all my FacSys faxes in that form instead ...help with Reporting-MTA: dns; urgent!!
I get a lot of messages that could not be delivered, the error message is as
Yah, some e-mail servers are wonderfully informative in their error
messages. The fact that you get a lot of messages might hint that you
are being used as open relay. See
Jes�s Guti�rrez R wrote:
> I get a lot of messages that could not be delivered,...win2k sp4 with Exchange2003(urgent)
I have install win2k with sp4 (install smtp, nntp of IIS)
but in service
I could see mta stacks, routing engine, system attendant
Should I run forest prep and domain prep before install exchange 2003 in
Which steps should I forget to do ?
What are you not seeing?
You can't install Exchange Server 2003 without doing ForestPrep &
DomainPrep - if they've already been done you don't need to do them again.
MVP - Exchange
NEW blog location:
"mike3004" <...Please help me...its VERY Urgent
Hi to all
I have a problem taht is like...
I make a customize MS agent character
with the help of MS character agent editor. Now i want to integrate
this agent with my VC++ application but i am not getting how can i
code to integrate it or how VC++ take a .acs files to display that
animation or agent?
its very urgent plz help me as soon as possible.
"Adroit" <firstname.lastname@example.org> wrote in message
> Hi to all
> I have a problem taht is like...
> ...Help, urgent, connection to access database
I met a problem about access database connection.
I have a program reading data from access database through ODBC.
When the access database located on local server, and created ODBC
linked to local database,the program runs without problem, but if it is a
network shared database, and created ODBC linked to the shared database, the
program prompts error: "workgroup file is missing".
Yes, I used workgroup file in current database and set correct security.
So what's the problem? is problem of the ODBC drive?
you should not be using ODBC
Access stop...URGENT-Windows Live One Care Scan whacked my computer big time
I ran two of the three Windows Live One Care Scans...
1. Clean Up-get rid of unwanted stuff that might be slowing down your computer
2. Tune Up-defrag check, and do if needed (was not needed) might be more to
I've run these scans previously with no problems. I ran them tonight and
restarted my computer. When I restarted, had messages regarding Windows not
knowing which program to use to open something (I forget exactly how that
message is worded...it gives you the option to check the internet to find the
program or to browse)
I ignored the first message...thought ...Exchange 5.5 Message tracking ( urgent )
Can anyone remember how to enable message tracking on Exchange 5.5
Is it on the MTA Site Configuration properties or on Information Store
properties, and where do you configure the number of days it is kept...
It's been long time haven't worked with 5.5
"Thinkpad21" <email@example.com> wrote in message
> Can anyone remember how to enable message tracking on Exchange 5.5
> Is it on the MTA Site Configuration properties or on...Urgent! "Query builder Error: No entity" message in the workflow s
I think I deleted an entity which was referenced by a workflow, and now
whenever I go in the SETUP\Workflow screen I get a "Query Builder Error: No
entity" message. I can't even access the workflow list.
Do you guys have any solution to this problem?
1) Restore your database from a backup from before you deleted the entity
2) Import a customizations.xml file backed up from before you deleted the
3) Try re-creating the deleted entity, with the same name, and manually hack
the database to set the entity type code (something like 10001) to the same
a...RE: URGENT!! Enquiry regarding CRM problem
Hi! Thanks for directing to Techknowledge...
However, I am sorry that I couldn't find the techknowledge in the whole
Microsoft website...Would you mind pls forwarding me more info.?
A Million Thanks
>Look for Techknowledge 34755.
>After installing the CRM, I encountered some problem
while trying to access
>thorugh web services, in which the following error
>MSCRM Application Error Report:
&g...Urgent: Accessing CRM DB
We have CRM installed for our sales team. There is an in house application
which has to access the accounts stored in the CRM system. This is avery
urgent requirement and to save time we are thinking of accessing the crm
database directly to read the accounts (though microsft recommends the use of
SDK). My questions are
- Is this a safe approach (keeping in mind that we will just read the
information, not update/delete anything)
- What should be the query filters to pick accounts? Should it be
deletionstatecode <> 2 only?
The other question I has was, is it ok to create custom ta...MSCRM3.0 webcontrols --- Very urgent
I am working with MSCRM3.0 . Can we access the MSCRM3.0 controls in
Asp.net page? Eg: Is it is possible to display the crm picklist in my
Asp.net design page? If yes how is it possible? please inform me as soon as
possible. its very important...
Thanks in advance
You cannot use crm controls in your own asp.net pages. You will have to
recreate the controls which look the same.
> I am working with MSCRM3.0 . Can we acces...E2k3 Open Relay ---- urgent
I thought E2k3 by default was NOT an open relay.
How can I check and change if necessary ??? Server seemed to be hit by a
spammer over the weekend.
> I thought E2k3 by default was NOT an open relay.
> How can I check and change if necessary ??? Server seemed to be hit
> by a spammer over the weekend.
If all 17 tests pass, you're not an open relay.
If test 8 or so will show mail to <"firstname.lastname@example.org"> as accepted, it
doesn't mean your server relays, but mail will be accepted and you wil...URGENT: Formatting ADO style XML
I am writing a windows form that will query the database.
string query = "SELECT TOP 2 * FROM Northwind.dbo.Customers" ;
DBQuery Q = new DBQuery() ;
bool result = dbCommander.RunQuery(query, true, ref Q) ;
stream = new MemoryStream(Q.DataAsByteArray, false) ;
stream.Position = 0;
XmlTextReader xmlReader = new XmlTextReader(stream);
DataSet ds = new DataSet();
ds.ReadXml( xmlReader );
// does not give me anything...
Debug.WriteLine( ds.GetXml() );
Here is typically ADO style XML stream I rec...Urgent Help please Count or SUM ???????
I need to know how to count the values in a column witihn a query.
I mean I have a column risk factor and 3 values in my table of H M L,
I would like to produce a query that counts all the H and allows me to
put that query dtright on to a table for emailing.
I have reached a point where my report already produced has the normal
=Count(*) embedded as a sub report for this value but it disappears
whn an email attachment is created.
I would now rather produce the email report with no sub reports or sub
forms on the report, just the report based on the query.
Of course once I have the formula ...Urgent Help Required
In the Exchsvr\bin folder I have a edb file name TempDFGR1232.EDB, that is
sucking up all the room on that drive, which is my C drive. Can I move or
delete this file. What's this file used for.
I use Windows 2003 Exchange Enterprise Edition.
On Tue, 25 Oct 2005 11:47:10 -0700, ChrisH
>In the Exchsvr\bin folder I have a edb file name TempDFGR1232.EDB, that is
>sucking up all the room on that drive, which is my C drive. Can I move or
>delete this file. What's this file used for.
>I use Windows 2003 Exchange E...Transfer cell data from one worksheet to another === URGENT
I do I transfer a cell data from one worksheet in Workbook A to
another cell in another worksheet in Workbook B.
Please stay in your thread
You have an answer there already
"rajesh" <email@example.com> wrote in message
> bello ALL,
> I do I transfer a cell data from one worksheet in Workbook A to
> another cell in another worksheet in Workbook B.
> Thanks, Raj
...urgent pls! sort date pivot report
Have a pivot report with dates. I like to data sort by date in ascending
order. so i did sort and top 10 -> asending
but i keep getting dates in this order ->
but i would like to get in this order
How can i achieve this ???
Also, i have count and sum formulas in the report, does this effect sorting ?
> Have a pivot report with dates. I like to data sort by date in ascending
> order. so i did sort and top 10 -> asending
> but i keep getting da...Function help needed urgently!!!
Hi anyone who can help...
I have two sets of figures 1 is sales and 1 is target.
Sales Target Incentive
In the Incentive column I want a formula that will
calculate the Incentive payment for employees who exceed
there target. The easy part is the if statement for
example 10% of their sales if they exceed target:
The complicated part comes in to play when only when they
hit multiples of 10 are they entitled to an incentive:
If the Sales are 5 and the Target is 5 - no incentive.
If the Sales are 10 and the Target is 5 - no incenti...Customisation not showing in Outlook..Urgent
I have added a button on the toolbar and set "ALL" in web.config for
customisation. But the button does not appear in Outlook Client CRM.
What more change in settings and where abouts am i missing?
you have to publish the customisations
"Atul Gadre" <AtulGadre@discussions.microsoft.com> wrote in message
> Very Urgent...
> I have added a button on the toolbar and set "ALL" in web.config for
> customisation. But the button does not appear in Outlook Client CRM....Urgent Help Please
I have a machine that cannot open its outlook. I am running Exchange 2000
on Server 2000, I have narrowed it down to either a WINS problem or a DNS
problem, I could oing the server from the machine using ip, but not name.
I'm not exactly sure where to go. I need help, this account is were our
electric invoices come into. I hope I provided enough info if not please
...cannot scrol on huge spreadsheet
i have excel 2003. some of our staff is working on a membership database.
all this info is in a spreadsheet. it is lots of info. thousands of records.
there is custom filters in the different columns. lets say they choose CTE
from the drop-down list than all the CTE records appear etc, however there
is 2 options e.g if they choose CTT or CCC then they can see the rest of the
records but only the page on the screen. In other words they can't scroll on
the page and there is definitely more records that can be seen on the
screen. why is this happening and can someone help ...renaming sheets-urgent
i have 50 records in a column. I want to have equal number of
corresponding worksheets named on the records. CaN THIS BE
AUTOMATED???? Also the number of records may also vary on a day to day
Please help me.
Your help is thanked in advance.
Message posted from http://www.ExcelForum.com/
This *might* be what you are looking for.
In Cell A1:A*, have the sheet names
In Cell B2, have =COUNTA(A1:A1000). (The range of names)
Make a new module with this code.
numberofrecords = [B1]
For numberofsheets ...Urgent!, IMF configuration wont keep the same
I have the IMF working very well, the only issue I have is when I set up my
custom thresholds and actions under "Gateway blocking configuration" they are
changed by it self to defaults the next day and I have to be changing them
back to my desire settings everyday. Does someone know how to fix this?
What version of the IMF? Are you managing it directly from the Exchange
Server? The only thing I can think of is that you are using the v1 version
of ESM extensions and Exchange 2003 SP2. Once you set the configuration,
it is stored in the Active Directory and the IMF...