How to average where 1 cell = x
Hopefully someone can help me out with this problem.
I have a list of data, and I need to find averages for each month. Is there
any function I can use that would effectively calculate: where [column A] =
x, then average column B values that correspond to x in column A?
Thanks in advance,
Depending on how your worksheet is set up, you may wantto try Sorting by your
Month Column and then using the Subtotals feature located in the Data menu.
> Hopefully someone can help me out with this problem.
> I have a list of data, an...Media center cant play TV after update
I updated a few days ago and now media center cannot do TV. I have the
mediacenter edition so it all came preloaded. I would ike to either A-
reinstall mediacenter with out doing a restore B-undo the last update C-try
anything you suggest.
I get no error messages. When I click anything that has to do with tv
(recorded TV, live TV, configure TV) media center simply quits responding.
Also, as long as I keep the "frozen" media center open, other things act up.
For instance, the start menu won't disapear when I take the cursor away, I
have to click the start button aga...Margin printing problem
I'm trying to print a document and it keeps cutting off a
tiny part of the right side of my document. I have equal
margins on the right and left and it has no problem
printing to the left side where it should. I'm not trying
to print borderless. I have my layout guides at .27. I'm
using an HP 1200 and my printer drivers are up to date.
Am I just stuck here because of this printer?? Is there
anything else I can try?
The HP site says you should be able to print within the margins you have specified.
Open WordPad, file, page setup, input zero into each margin, ...No Margin around email messages in Outlook
This is a multi-part message in MIME format.
In my preview pain window where the body of the emails are located, =
there is no left margin space. The letters are tight against the left =
window pane border which can make them difficult to read. Is there a =
way to adjust this, as well as the font size?
...RAND and only 1 decimal
I want to make a random number in a cell with the RAND function and then use
it in a calculation. Right now it goes to several decimal place and I need
it to only have one decimal in the calculation.
How can I do this?
Thanks for your help.
Microsoft MVP - Excel
"SAC" <firstname.lastname@example.org> wrote in message
>I want to make a random number in a cell with the RAND function and then
>use it in a calculation. Right now it goes to several decimal place an...CRM 1.2
For testing purposes i have tried to create a simple Workflow rule (manual)
with only a posturl action. I have tried it for different objects and with or
without parameters. The result is the following error:
MSCRM Platform Error Report
Error: <description>Error in action posturl.</description><details>Failed to
connect the url
http://sthutvsrv1:8082</details><file>d:\crm\core\src\platform\workflow\service\processengine.inl</file><line>5280&...Downgrade RMA 2.0 database to 1.3?
Is there anyway to do this?
NO. Can go up but not back unless you have backup from before the upgrade
...Keeping Row 1 At Top When Scrolling?
How do i make it so that the top row, row 1, stays at the top of my sheet no
matter how far i scroll down the page?
Select cell A2 and then go to the Window menu and choose Freeze
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"KMc" <email@example.com> wrote in message
> How do i make it so that the top row, row 1, stays at the top of
my sheet no
> matter how far i scroll down the page?
> Ma...Resolution to CRM 1.2 database export failed error during 1.2 to 3.0 upgrade
After struggling with this error working with MS Support and receiving
no resolution, we were able to solve the problem through KB article
916924 (see below). Why MS Support did not point us to this in the
first place is quite frustrating, so hopefully this will help others!
This problem occurs because there are saved queries in the Microsoft
CRM 1.2 databases that are malformed. This problem usually occurs
because a third-party product is not completely removed from the
Microsoft CRM databases before you upgrade to Microsoft Dynamics CRM
This problem occurs if th...Charting #4
Is there a way to make the default setting for the horizontal axes on
charts set to no line? It is really annoying. When you have 3
different overlayed charts and you have to change this setting it is
very time consuming. Every time I save the document it does not save
this setting. Any ideas?
...2 different loan payments within 1 transaction
I'm using MS Money 2006 and I love the functionality so far, but I have
recently run into this new problem. It's kind of a rare occurence, so I hope
someone can help me out.
I have 2 student loan accounts, one subsidized and one unsubsidized so they
can't be consolidated further. Both of these loan accounts are set up
separately within MS Money. The problem seems to be that only ONE combined
payment (transaction) goes towards both loans at once. This one lump sum
gets automatically divided at roughly 85%/15% between the loans.
Now, I've split income transaction...vlookup formula #4
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C8FEBA....Database Query #4
I have created a data table in a worksheet and named it “data”. Then I
created a separate worksheet, in the same workbook, and created a database
query of the data table, by using Data…Import External Data…New Database
Query…Excel Files* and defining the database name by browsing to the same
workbook. The query worked fine. However, when I moved the workbook (which
included the data source) to a different folder and tried to refresh the
database query, I got the following error message:
“[Microsoft] [ODBC Excel Driver] The Microsoft Jet database engine could not
find the object ‘data’...Windows Media Center ??
Is it possible to run windows Media center under windows xp-
The links that I can find seem to want you to up grade to
windows 7 ... there are some old posts to downloads for the
center .. but these seem to be now upgraded to windows 7
I have a hap TV card .. which requires the media center to use
the dual tuner facility ..
not - windows media player .. this is not suitable
tnx - G .
WinXP MCE and WinXP Pro are pretty much (but not quite) the same thing.
If your hardware is compatible, you might consider "upgrading" to ...Secure Call Center Tracking
I'm looking to use MS CRM to track our members and what contacts we have with
them. One of our departments operates a call center for Health Insurance
question. They often deal with HIPAA covered info. I was hoping to add a
checkbox labeled "secure", that if checked, restricts all access to just this
particular group. Is this possible? Is there a better way? Should I just
create a custom entity for call tracking and restrict access to that entity
to just their team?
Association of Washington Cities
Doug - Yes, it is possible with the ch...Install CRM 1.2 Outlook client
I still have problems working with Outlook CRM client 1.2
after installing. The only things who where shown right
are the icons in the 2 taskbars. When I push (for example)
the CRM home button, the right part of the screen is
white. Not any format is visible, only a view words coming
from the menu tree and a view picture frames (only the red
cross, not the picture).
We reinstalled the total server. We are using virtual PC
with an image with the 1.2 client version (based on the
image of the 1.0 version: reconnected it to the new domain
and installed the 1.2 version after uninstalling...Excel VBA
Hi Excel VBA advisers!
I have a userform where there are two text boxes (drugdesc1 &
drugdesc2) that I want to force 4 commas to be keyed into both fields.
4 commas are MANDATORY in each text box & are used to separate the
type of input within each. ie; brand name, ingredients, strength,
form, pack size. (FYI: Later on, I split these fields into 4 separate
columns based on the comma delimiter.)
When "cmdAdd" command button is clicked, I need to display a msgbox to
advise user and disallow the add.
I imagine that the code (repeated for each text box) that I would put
in th...CFile #4
I have the next code :
CString Ca="Line 1",Cb="Line 2",display="";
fsal1.Open ("C:/100.Log",CFile::modeCreate | CFile::modeWrite);
ANd the results is : Linea 1Linea 2 (together)
If I want to write "Line 2" under "Line 1" What do I need to adjust ?
ANy other suggestion are welcome !!
Use CStdioFile instead of CFile i...Automatically add 1 until a number is found
I am developing a spreadsheet which basically grosses-up a paymen
which i have to make to an employee.
What I'd like to do is take a cell and add 1 automatically until th
number equals a specific equation. Is this feasible?
Message posted from http://www.ExcelForum.com
Have a look at Tools / Goal Seek. It might be what you are looking for.
"jkyndt >" <<firstname.lastname@example.org> wrote in message
> I am developing a spreadsheet which basically grosses-u...Service Pack 1 2003
I am in search of a step by step guide to install SP1 for Exchange 2003 on
Windows 2003. I have read through the release notes, but that was not much
help and I have read several articles about you have to rebuild the RUS and
things like that. Can anyone point me in the direction to find instructions.
To rebuild the RUS, right click on it and select rebuild.
MVP for Microsoft Exchange Server
"James M" <JamesM@discussions.microsoft.com> wrote in message
news:D5485042-144D-4327-AE5D-94C430C8A547@microsoft....CRM 4.0 E-mail Router poll frequency
How often will the E-Mail router access the Exchange mailboxes being
monitored? I waited for 15 minutes with 3 new message hanging in the inbox. I
restarted the service and they all came in. The performance counter "Incoming
mailbox access attempts" didn't move for the 15 minutes i waited. After a
restart -- furious activity for a few seconds. No errors/warnings were logged
to the event log.
Can this be controlled somewhere?
I have almost the same problem there can go up to 1 hour before the email is
going trough the system.
If you found a solution pl...Fix for 12.1.1 error a version of the software required not found
12.1.1 updater woes- a version of the software required not found
In case the above link does not work:
I have never done any of the things that the article states would cause the update failure. Now to have to completely reinstall the software, I am not happy.
There must be something else going on here.
yeah i used monolingual.
> yeah i used monolingual.
Did the fix work?
Just had the same problem afte...E2k3
I've strange trouble with Exch 2k3. POP3 works fine, there's no problem.
However, SMTP clients cannot send mail. On the server, SMTP is cinfigured to
allow relay for authenticated clients only. On the clients (all I have seen),
the authentication is enabled. However, server returns:
----- Outlook Express error -----
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'email@example.com'. Subject
'Test mail...', Account: 'Test', Server: 'xxx.xxx.xxx.xxx', Protocol: SMTP...Right click in Outlook 2000 SR-1
The menu doesn't appear when right clicking on messages.
There is no problem right clicking in any aother
application or with the Windows 2000 OS.
...Move Mailbox #4
after an in place upgrade from NT4 to W2k3 nd after a connection agreements
and after exchange 2003 instal I am having problems moving mailboxes.
I cannot get the context sensitive properties to render on a mailbox to
select a move. The only mailbox that will render the Exchange task context
sensitive menu for the move mail box option is the acount I used to setup the
connection agreements and to install Exh2k3. This account has all the
pre-requisited permissions to do anything in the domain.
I can move this users mailbox back and forth from exch 5.5 to exh2k3 no
ADC logs indic...