Tell the difference between upper and lower case
I have a column that has letters in it and I am using
=COUNTIF(D13:D27,"M") in one cell
=COUNTIF(D13:D27,"m") in another.
to keep track of what letters are put in the "D" column. But the
both count the upper AND lowercase letters. Is there any way to mak
excel tell the difference between upper and lowercase letters?
Message posted from http://www.ExcelForum.com
>=COUNTIF(D13:D27,"M") in one cell
>=COUNTIF(D13:D27,"m") in another.
>to keep track of what lette...Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.
"counted with 5%"
5% should be taken from the cell and used in the title.
Is this possible?
Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
Andy Pope, Microsoft MVP - Excel
"Nicole" <Nicole@discussions.microsoft.com> wrote in message
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...Auto start (and Stop) downloading from POP accounts.
My ISP rpovide me a free time to use internet conection between 2.00
amto 8.00 am.
My ISP charges me on the maount of data send / receive by me on MB
So, is any way that the MS profesionsl edition 2003 (outlook) starts on
2.01 am, starts downloding / sending the mails from POP accounts. and
stop at 7.59 am.
Is any trick available , please let me and other esteem members of this
thanks in advance.
Schedule a task (in Win), ie to start OL (I assume you will have configured
OL for polling)
Then schedule a shutdown/close of OL
"Prince" <r.r.makwana@gmai...Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...Using expression builder object
I'm developing a wizzard in Access which builds import templates for various
data sources to a fixed set of tables. In step 3 the users must be able to
build an expression ; for instance Left([Fieldx],20) . Now I would like to
have a command button on my form which calls the Access expression builder to
allow the users to use this to build the expression. This expression will
then be stored in a text box linked to the templates table.
Anybody know how to call and use this object from VBA code?
I th...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...Outlook "Ruler" won't go away
I don't know how I turned this on so I don't know how to
turn it off. It splits my emails so that I can only type
so far over before it kicks me back to the left margin
and makes me start a new line. Can anyone help me?
...hyperlinking email addresses
I have a list of email addresses that have hidden text before the first
letter of the email address. I tried all the functionalities to get rid of
this spacing/hidden text, but, it does not work. Now I am trying to
hyperlink the email addresses, how do I do that?
Most likely a non-breaking space...........char 160
CLEAN and TRIM will not pick it up.
What: Alt + 0160(on numpad)
Gord Dibben MS Excel MVP
On Sat, 9 Jan 2010 13:44:01 -0800, CharlesZ
>I have a ...Outlook 2003
we have one client pc with Outlook 2003 where the following problem
if a mail is replied from a user created sub folder of the inbox, the
reply will not appear in sent mails, but will end up in the same sub
folder, sender and recipient appear as identical. The mail goes out
properly though, it's just that Outlook sets internally sender =
recipient and bounces the reply back to the subfolder in which the
original mail is stored.
This happens on a Win 2000 machine with SP4 and all updates, the other
clients use Outlook 2000 or XP and there is no such problem.
There are no ru...Filter recordset using query results
I have a form based on a query called [qry Quarterly Planning], it lists all
Itineraries on the system. On this form you can filter records by specifying
a Start and End Date for the [ReviewDate] and/or [Specialist]. It is a
subform on a main unbound form, lets call this Subform1. Along side this I
have another subform (Subform2) which displays ReviewDates that exist
against an Itinerary. In other words Subform1 has a start date of an
activity and if the activity lasts longer than 1 day, then the additional
dates are stored in Subform2 (ItineraryDates). Currently when I...how do I connect an object from one page to a different page?
I am trying to connect an object from one page to a seperate object on a
different page. The instructions say to hold down your mouse button then
click on the point you want it connected too. My problem is that is doesn't
allow you to select the starting point of the connector, then select a
different page, then click on your end point of the connector. Please help!
try using a hyperlink.
"Pepper" <Pepper@discussions.microsoft.com> wrote in message
>I am trying to connect an object from one page to...How do I use traffic lights in excel
I am wanting to use traffic lights in excel that change colour based on the
result of a variance cell, ie if the result of the cell is 10 make the
traffic light green, if it is 20 make the traffic light amber, if the result
is 30 make the traffic light red. How do I do this?
Format>Conditional Formatting>Cell Value is:
Note: you can add up to 3 conditions(4 if you count default)
Gord Dibben Excel MVP
On Wed, 22 Dec 2004 16:35:03 -0800, Shorty <Shorty@discussions.microsoft.com>
>I am wanting to use traffic lights in excel that change colour based on the
&g...Incoming email slow to come in
Don't know if anyone can help, but here goes. We are running an
Exchange 5.5 server and I am running Outlook 2003. Email that is sent
to me internally is very slow to arrive (up to 30-45 seconds),
including email I send to myself. Nobody else in my immediate vicinity
is having the same issue, their email arrival is instant. We have
reviewed Outlook settings and they are identical. One strange thing is
this: If I send myself an email, don't do anything, it will come in
within 30-45 seconds. However, if I send myself an email, then
immediately send another email both of them will ...Outlook Express 6 w/multiple accounts
I have three accounts set up in Outlook Express 6. Two of
them work fine, but when I reply to or forward a message
sent to the third address, it uses the second address in
the "from" line, so I have to change it manually. This
does not happen with the other two. How do I fix this?
...Linking information form one worksheet to another
Hi, i have a big problem
i want to create a link between some columns in two seperate worksheets, so
that when i type a name on the master sheet it would give me the required
information.Dont know if i explained this right, lets say on the master sheet
i have columns : Name,Sex and Height on columns A,D and BH respectively i
want that if i type a person's name in worksheet 2 it should give me the
results on columns A,C,F in that worksheet. Please help i need it asap for my
One way ..
Assuming your "master" sheet is named: Master, with data in row1 down
In Shee...Newbie Question: Using Web Services
I've been trying to implement Infopath with CRM with no success. I've
tried the example, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmbscrm1_2/html/mbs_crminfopathcrmintegration.asp,
to no avail. I have followed the example to the letter, but find the
information about publishing the Web Service to the server to be
somewhat lacking. Admittedly, I am not a programmer, and I am
continually running into an error in line 54:
Has anyone else ...Email Router Failing with System.UriFormatException: Invalid URI:
I cannot seem to get a handle on this, even with a very basic email workflow
The rule is simply to watch firstname.lastname@example.org. If any email goes in, send a
notification email to email@example.com
The Server has the following error. Anyone have any ideas?
Event Type: Error
Event Source: MSCRMExRouterService
Event Category: None
Event ID: 0
Time: 4:01:50 PM
System.UriFormatException: Invalid URI: The hostname could not be parsed.
at System.Uri..ctor(String uriString, Boolean dontEscape)
at Sy...Exchange 2007 across account search
Does Exchange 2007 has an option to search all users mail for keywords?
That all SBS workgroup users can search for messages to/from all other
Is there any advanced indexing system to speed up search results?
On Tue, 26 Jan 2010 14:22:12 +0200, "Ronald" <firstname.lastname@example.org> wrote:
>Does Exchange 2007 has an option to search all users mail for keywords?
>That all SBS workgroup users can search for messages to/from all other
>Is there any advanced indexing system to speed up search results?
Bunch of ...Using Visio HTML output within frames
I want to include visio HTML output in a frame of another html file.
Unfortunately it is not working.
I understood the problem is in vml_*.htm files. It is due to, the
target arrtibute(pointing to _parent) in v:shapetype tag and
href attribute (pointing to #) in v:shape tag. These attributes should
point to "_top" and "<target-html-file>#" respectively inorder to work.
I want to change these options while saving .vsd as web page?
I would appreciate if you can help me in this regard.
coor...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
email@example.com...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...outputting values to a range from one formula
I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.
Can anyone help me on that??
---------------------------------------------------------...Is there a way to schedule a email to send out at a certain time?
I tried delay the mail, but the sent hour is not right.
For example, the email should go out at 8am, but the sent time is 5:30pm
which should be 8am also. Please help!
"Grace" <Grace@discussions.microsoft.com> wrote in message
>I tried delay the mail, but the sent hour is not right.
> For example, the email should go out at 8am, but the sent time is 5:30pm
> which should be 8am also. Please help!
The Sent time and the delivery time are completely separate. The Sent time
that people will see w...Error After Customizing 'Accounts' Form
Earlier today, I created an onSave event along with some other
customizations for a tab in the 'Accounts' form. After becoming comfortable
with my changes, I published the form and tested with a small Account that we
do not access much.
One of my fields was planned to be read-only, but I had it writable for a
test. When I typed a value into the field and saved, I received an error and
I can no longer open the specific account.
I found the problem with the custom field and fixed it. However, I am still
unable to open that one account.
Here is the error I received:
...My Homepage and Emails
On the "My Homepage" I have 53 emails in progress...
However these emails have all been either sent or received, and are not
"open" as such.
Is there anyway to "close" off these emails so it does show in My Email
and as In Progress?
Select all from the In Progress Queue and Action >> Delete
If they are emails, this will clear it from the In Progress Queue, but won't
delete the actual record.
San Francisco, CA
> On the "My Homepage" I have 53 email...