Averaging cell's...problems with Div/0
Hi guys. First time poster here so be gentle with me. I am looking fo
some assistance averaging a range of 1 to 3 numbers.
Here is what I have so far.
This works great. What it does is checks to see if there is a value i
the cell, then counts it and divides by the right number. I.E if yo
only have two values out of 3 filled in it divides the number by tw
instead of 3.
My problem... if all 3 fields are 0 then I get a divide by 0 error.
Any suggestion on how to fix this? I don't want my spreadsheet to loo
messy before I start plu...vlookup help #3
I cant figure out the proper syntax for the attached workbook. Th
first 8 options on worksheet two work perfectly ( ie when checked, the
appear on worksheet 3) I dont know how to apply the formula of th
first 8 options to the rest of the checkboxes.
Can someone please help me figure out how to do this? Thanks i
Attachment filename: start order2.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=46674
Message posted from http://www.ExcelForum.com
Right-click on the sheet tab for the Options worksheet.
Select View ...How do you change a field name in 2002 Excel
I have copied and pasted a whole database from Works into the Excel
program but can't seem to find a way to change the field names from A,
B, C, to what I want as Last Names, First Names, etc.
Aarrrrgh. It can't be THAT difficult! <G> Using the HELP did nothing
for me thus I am here asking this silly Q.
AnnE in MN
You cannot change the Column letters from A, B, C etc.
You can choose to have column and row headers not shown under Tools>Options>View
Enter your titles(names) in row 1 then select A2 and Window>Freeze Panes to lock
row 1 in view.
Gord Di...How to change the color of CComboBoxEx
I have derived my class from CComboBoxEx and I change the colors
(SetBkColor and SetTextColor) in OnCtlColor() in response to
CTLCOLOR_EDIT and CTLCOLOR_LISTBOX; I also return my brush;
As a result the colors of the edit part of the combo do change but in
the listbox only the space around the text is painted. The text itself
and its backgound remain as the Windows defaults.
"David A. Mair" <firstname.lastname@example.org> wrote in message news:<ObKF5Q#bDHA.2632@TK2MSFTNGP12.phx.gbl>...
> I have it working OK, here's my CColorComboBox::OnCtlColor():
> HBRUSH CColorCo...CRM Url
I initially installed the CRM server to the default url of the server
(i.e. http://servername). I then installed SharePoint and it messed
the configuration up. I then uninstalled SP. Now I can't get to the
default server's url of http://servername.
Any suggestions on how to correct?
Go into IIS and setup a Host Header for the CRM site, Then add an alias for
the Header to DNS. Calling the Alias will then resolve and access the
Paul Papanek Stork
MBA, CTT+, MCT, MCSE+I, MCSA, MCAD, MCDBA
Solutient of Ohio, INC.
email: pstork <<at>> att.net
visit ME at: ...Login problem to CRM 3.0
I installed CRM 3.0 Professional Edition without any error. I can login
perfectly from the CRM server either using http://localhost:5555/ or
http://appserver:5555/ under the crmadmin user.
If I login to an XP workstation with the same user (crmadmin) and
specify http://appserver:5555/ in IE6, I got a login window - where I
enter the correct DOMAINNAME\crmadmin username and password - and got
the following message: "You are not authorized to view this
page"..."HTTP Error 401.1 - Unauthorized...
I think the prolem is around IIS security, but what shoud be the next
Th...Change from SBS 2003 to SBS 2003 R2
Does anyone know if the license from Windows SBS 2003 works on R2
Here's my situation:
I have an old server running Win SBS 2003. This is a new client and i
just found the installation to be all screwed up (they are not even
using Exchange, the domain is not .local, I cant find the SBS
management panel, etc ) and barring any magic solution that allows me
to improve on the current install, what i really want is to start from
scratch, probably on different hardware (new server).
So I whas thinking to my buttons:
During reinstallation, can I now use the latest ver...look way to map form at CRM frontend to tables at CRM database
How can I find out what tables which new record has been added on when I
enter data through a form in CRM front end? I try to find way to map form in
the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0
Thank in advances for help!
...Changes Since Moving to Exchange
I have subfolders within the inbox, and then subfolders within the
subfolders. I also have rules so that when a message comes in from a certain
person the message goes into their folder.
Before we moved to our new exchange server if someone sent a message and the
message went to their folder, the number of unread emails in the folder
changes (ie, if Joe Bloggs sends an email to me his message goes to the Joe
Bloggs folder, and it looks like Joe Bloggs (1)). And the folder that the
'Joe Bloggs' is in (for this example it could be 'staff') would also...Renaming Accounts in CRM
We are trying to change the account name in CRM, In the Account Name
field when we chnage it, it goes through all cases and makes the owner
of the case the person that changes the account name. Is there a way
to have it not go back through all of the cases ?
What you describe is not CRM functionality. Either you didn't describe it
correctly, or there is some custom process performing the unwanted action
I think you may mean when an account owner is changed, all the account's
cases ownership also changes. Now that really is a pain!!
"Rcw01" <email@example.com> w...I cannot uninstall CRM client for Outlook
We have two clinet machines that had CRM client for Outlook with Office 2003.
We upgraded those workstations to Office 2007 and subsequently lost the
ability to use the CRM features. When I try to uninstall the CLient, the
uninstall asks for the disc and proceeds to reinstall the client until it
realizes that the new version of outlook is incompatible. When trying the
newer install disc for CRM, I get the following message: "The older version
of Microsoft CRM desktop client cannot be removed. Contact your technical
support group." This is followed by " Action
Micro...Dlookup turn -1 or 0 into a word
I have a message box that displays if a product is 'Stocked' or 'Not
STocked' but in the databse its stored as -1 or 0
I use the follwoing code
DLookup("StockedItem", "tblProduct", "ProductID=" & Me.ProductID)
So in the message box at the moment it says -1 or 0, how do i code it
to says 'stocked' if -1 and 'Not STocked' if 0
Assuming ever field has a value:
If Stocked = -1 Then
MsgBox "Stocked", vbOKOnly
MsgBox "Not Stocked", vbOKOnly
Arvin Meyer, MCP, MV...How to assign unique number to column duplicates?
I need to assign a unique number to a set of duplicates all in one column in
so columnA will has about 9000 numbers, some of them unique, and others are
duplicates of 2-4 approx.
I used to conditional formatting to show which are duplicates, but need to
be able to assign a unique number to each set duplicates, that will be in
ColumnA ColumnB(unique ID)
Any ideas please? I don't know how to do programming, just form...I am having trouble keeping numbers formatted in a Pivot Table
I have a pivot table that won't stay formatted. The data is formatted as
currency in the worksheet that the Pivot Table is drawing off of. It shows up
as a general number in the Pivot. I've tried formatting it in the Pivot but
it doesn't stay when I refresh the data. "Preserve formatting" is checked on
the Pivot table, so it SHOULD be preserving any formatting I apply to the
pivot table, but that doesn't seem to be happening. I know I could record a
macro to format this, but it is happening on multiple Pivot tables in the
same workbook and that would be a pain ...Get Start date of Week number and Year
I’d like to build the following expression in my query
So if EnteredDate = 11/3/2009 the function would return 11/1/2009
But GetStartWeekNumber does not exist as an Access Built-In Function.
Is there another way to do this as an expression in a query?
I’m not familiar with creating my own functions.
That would depend on how you define the start of the week...
One option would be to get the day-of-week number of the date (in my
system/setup, Monday is day 2), then subtract one less than that...Prevent excel from changing numeric data ranges into dates?
I want to prevent excel from changing my numeric data into dates (ie. 10-12,
into 12-Oct). I want to import specific data ranges, not a date values.
Whenever I paste or type a possible date, like 10-12, excel assumes I am
writing Oct. 12, 2004. Then, Excel formats the cell into a Custom d-mmm
format (see scrn shot @ www.vd4.org/excel_issue.gif).
If I change the Custom format to General, excel converts the date into the
DATE'S value (ie. 12-Oct, into 38272; which I think is the # of days since
How can I *prevent* excel from changing my data ranges into dates (ie keep
10-12 ...MFC and threads #3
I am running into a problem when trying to pause a thread in MFC based
application. This is my first time using user defined Events for
synchronization. The scenario is like this. Code executes in a worker
thread and based on some conditions thread launches another new dialog
window. That window displays some message to user ie, Hello There! in
an Edit control. I provide a Resume button on the bottom of that
message Window so that user can continue after reading the message and
the worker thread should continue from where it left off. This is the
code for that Resume button.
v...Copy and Paste not saving format changes
Operating System: Mac OS X 10.5 (Leopard)
I just bought Microsoft Office for Mac early this month and am still getting used to it. Can someone help me with this:
I have several documents typed onto a notebook layout with lots of bullet points, color changes, cross outs and the like. I wanted to copy and past all of that into a new document but when I did ALL of the formatting changes were lost. There were no bullet points, so the text flushed left, yada, yada, yada.
I looked around the toolbar to try and find a setting that would allow me to do the cut an...Outlook 2003 offline caching changes
There has been a change in the default behavior of
Outlook from version 2000 to 2003 with regard to how the
offline cache responds when you have previously
synchronized the cache, and then reconnect online (in our
situation, it's particularly relevant when connecting
over a phone line rather than over a broadband or network
connection). We're wondering if there's a way to turn
back the clock..
In Outlook 2000, you would connect to the online mailbox,
and would view all the headers of all the messages in
your Inbox, Deleted Items, etc. (you still had to wait
for the head...Send #3
Messages waiting to be sent are NOT formatted in italic in
the Outbox, and therefore remain in the outbox after
Hi - please tell us your version of Outlook, what service pack you have,
what mode if applicable (see all this in help | about) and what kind of
e-mail account you use.
> Messages waiting to be sent are NOT formatted in italic in
> the Outbox, and therefore remain in the outbox after
I have a field called "TimeStamp" What I would like is that if someone
modifiys or make any change in the form that the "TimeStamp" will record
the time and date of change.
How can this be achieved?
In an event procedure in the form's AfterUpdate event, you could do
Me!txtYourTimeStampField = Now()
Note that if you use the BeforeUpdate event, every time your code changes
the value of this field, the form tries to update, the BeforeUpdate
(re-)triggers, and you "loop up" (at least, it seems to me I've seen
this...)...Changing Paper Size
We print a monthly newsletter which includes a pullout insert. This
month we want to turn this pullout into a foldable brochure. Before I
send it off to the printer (who prints our newsletter to 11X17 glossy
paper), I want to make sure the pullout, when folded, displays the
information correctly (not upside down or out of sequence).
We print to a photocopier that users 11X17 size paper. I cannot
figure out a way to print two successive pages (8.5 X 11 each) to one
sheet of 11X17 paper (ie., pages 2 and 4 to one sheet of paper). I
tried doing this by changing the printer options to 11X17 b...Changing Costs in Detailed Sales Report
I just opened a new location and I have specified my costs in HQ Mgr under
Supplier Tab in Item properties. And I also checked the Supplier tab in Item
properties in the Store Ops Mgr, my cost is there.
But when I ran a Detailed Sales report for yesterday, some of my items'
costs are missing and listed as $0.00. So I open HQ Mgr and issued Worksheet
302 for the new location. I did a couple of test transactions today and ran a
Detailed Sales report for today, and it shows the costs of the the test
But detailed sales report for yesterday still shows $0.00 costs. How do...How to Replace Numbers with Phrases
...Failed CRM for Outlook Install
I am trying to install CRM for Outlook on a computer but it kleeps failing
with the following error:
"Setup has failed because of an error. Setup was unable to install the .msi
file for Microsoft CRM Sales for Outlook"
The user has Administative rights to the system, she has an account in CRM
and a license. This is very frustrating since I have to clean up the registry
every time I reinstall since it crashes before putting anything in the add
remove control panel.
Try to uninstall MSDE and make sure you have all the databases removed.
The default in...