Comparing fields in an excel worksheet
I have some fields that I need to compare and extract the equal letters and
For example, the fields are like this: DKLJSAIM; PLAIQBN.
I need to compare this 2 fields and extract the differences between them.
Does anyone knows how can this be done?
take a look at CPearson web
> I have some fields that I need to compare and extract the equal letters and
> different letters.
> For example...Equation Numbers, inserting field
I have a list of equations in a word document that I need to add a reference
(the first equation in the document will be equation A, the second will be
equation B, etc. When I get to equation 27 it needs to be AA, then 28 will
be AB...) next to. However, I will be adding other equations randomly
throughout the document and referring to the equation reference in text
paragraphs. I would like to have both the equation reference and the text
paragraphs to update if I add an equation to the middle of the document. I
know I should use a field code and cross reference it in the tex...How to make a waterfall chart
I have to create a Waterfall chart (not to be confused with a cascade chart)
like the one shown at
http://www.ozgrid.com/Services/excel-waterfall-chart.htm. This is just a
one-time deal, and I don't feel like buying the add-in. I would rather learn
how to do it myself. Does anybody know how?
have a look at
Lucas Bravo wrote:
> I have ...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...Web service error
When I Call the CRM webservice from an aspx page the first time I get this
System.Net.WebException: The request failed with HTTP status 401:
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
methodName, Object parameters)
If I click refresh it gets me the correct data.
Could this be the solution ? Anyone tried it
-----------------------------...Can't Make Brochures
To make a brochure, I open up Publisher, go to 'Publications for Print' ->
'Brochures'. No matter which design I select, about 5 seconds after the
'Changing your Publication' window comes up, another window pops up telling
me 'Publisher cannot complete the operation'. This only happens for brochures
- all other publications work. Does anyone have the answer?
Try a detect and repair in the Help menu. Do a disk clean-up. Don't delete the
Office setup files if you do the disk clean-up. The clean-up is found by right
clicking your hard drive, propertie...Changing field settings on multiple columns in pivot report...How
You have brought up a pivot report but it defeaults to count for all columns.
Can you change all to max with one operation?
You can't manually change all the calculations to MAX with one step.
You can change each field individually, by double-clicking on it, and
changing the summary function.
Or, you can use programming to change all the data fields. For example:
'changes data fields to MAX
Dim pt As PivotTable
Dim pf As PivotField
For Each pt In ActiveSheet.PivotTables
For Each pf In pt.DataFields
pf.Function = xlMax
Next...how do I make place cards #2
I am trying to make small, tent fold table assignment cards, using a guest
list that I have created in Publisher (2003)- I want to use the 'name'
'title' and 'organization' fields from my guest list to create the cards, and
add a table assignment field, with one table/name/title/organization per
card, but am not sure what template to begin with- Do I need to select an
Avery product first and then create the place card document, then do a mail
merge or start from Word, or...? Thanks in advance for your help-
What are your dimensions? Will the card have printing on...Tab clears field
I have a form. It has a comi box for the first field. When i depress the tab
key to move onto the next field the name field clears. I do have the data
entry set to yes so on open the form is clear but can anybody tell me why it
is doing that?
In Form Design View goto the Properties Box - Other and set the Cycle
Property to "Current Record"
>I have a form. It has a comi box for the first field. When i depress the tab
>key to move onto the next field the name field clears. I do have the data
>entry set to yes so on open the form is clear but ...Service
Can you have CRM monitor an email account and open tickets form this box.
Thus could a client open and or update a ticket from an email.? Would I need
to employ the use of the tracking icon?
If I have this right you want to receive emails to global email address and
then have a case created automatically from the email.
If this is correct then you can use Queues to create a ServiceDesk global
email storage and use workflow to create a case when an email is received on
MCDBA 2000 | MCITP DBA 2005
"CGM" wro...Date/Time stamp in Memo Field
Hi all..is it possible to programmatically insert Now() when text in a Memo
field becomes edited?
Thanks for all help!
If it has to be entered directly in the memo field tetxbox:
Private Sub MemoFieldName_AfterUpdate()
If IsNull(Me.MemoFieldName.OldValue) Then
Me.MemoFieldName = Now & " " & Me.MemoFieldName
Me.MemoFieldName = Left(Me.MemoFieldName, Len(Me.MemoFieldName.OldValue)) &
" " & Now & " " & Right(Me.MemoFieldName, Len(Me.MemoFieldName) - Len(Me.
Me.Dirty = False
End...How to register a service process in win2000?
My PC's OS is win2000,and I want to register my current process into
service process.How to do?Thank you.
You don't. You are working in a Unix model where any application could be a service. In
WIndows, a service must be created as a service, and there Is No Substitute. Also, your
service must not have a GUI, or attempt to communicate via a GUI.
On Sun, 2 Jul 2006 10:16:39 +0800, "Lee Tow" <firstname.lastname@example.org> wrote:
> My PC's OS is win2000,and I want to register my current process into
>service process.H...email address on Service Call Entry window
Add an email address field to the Service Call Entry window for the customer
contact on the service call. Even if it is not pulled from the email address
of the address id on the service call, at least the dispatcher could enter an
email address on the service call in order to communicate with the customer
regarding the call. It is common to take email address as part of contact
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the m...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Error 1606 Money Service Pack 2002
I have tried all of the suggested fixes that I've seen on these boards for
the error 1606. I now have no money program, I can not reinstall the money
program and the error still pops up in my Turbo Tax and it is driving me
crazy! I can not delete the service pack from the add or remove programs
applet. I would very much like to finish the taxes before the 15Th. Does
someone know what is going on? I've deleted registry keys, done clean boots,
tried to eliminate every vestige of the program that can be found yet, when I
try to reinstall from the disk, I'm stymied by Error...Zero filling a number field
I have an auto number field that I want to zero fill to six digits but
can't figure out how. Any ideas?
You don''t say where you're trying to do this, but basically
>I have an auto number field that I want to zero fill to six digits but
>can't figure out how. Any ideas?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
You can't do that wi...Change of field separator
When I open CSV files in Excel all data is put in one column. Can anyone tell
me, where I change my set up, so I get another field separator? Please be
specific, because my Excel is a Danish version, and sometimes I have a hard
time following the English instructions. Thanks!
you specify this in the Windows regional settings. Another idea:
- rename your *.csv file to a *.txt file
- now open it with excel. The Import wizard should appear and should allow
you to specify a different delimiter
> When I open CSV files in Excel all data is put in one co...Update MSN Services with Money 2007
How can I update the Portfoglio and Accounts on MSN with MS Money 2007
Deluxe version ???
Thank you. Bye.
In microsoft.public.money, Paolo B. wrote:
>How can I update the Portfoglio and Accounts on MSN with MS Money 2007
>Deluxe version ???
Transactions that you enter yourself into Microsoft Money 2007 would
not be forwarded out to MSN Money. This keeps that info on your own
For institutions with their own OFX servers, you would have to set
up those accounts to download into MSN Money also.
Accounts where the data comes in via "third party" ...Automating Auditing of Directory Service Objects
Hi. Is there a way to automate the deployment of Auditing settings to
the OU's in AD? I only have a handful so it doesn't have to be TOO
efficient. These have to be deployed automatically (via script,
command line or whatever) if at all possible.
Is this possible? If so, where can I start looking?
On Wed, 19 May 2010 06:42:49 -0700 (PDT), Neil
>Hi. Is there a way to automate the deployment of Auditing settings to
>the OU's in AD? I only have a handful so it doesn't have to be TOO
>efficient. These ...Query fields
Is it possible to write a criteria where the value of an empty field is "0.00"?
Background: I have three queries with different customer account groups. Not
every salesperson has customer accounts in every accountgroup - so, he will
not shown up in that query. But he has accounts included in another query.
Now, I would like to get a sum of commission earned by each salesman
calculated from all three queries together.
Since the salesman has no record in one query the total sum of that specific
salesman is not shown.
Any idea how to solve that problem?
On Wed, 29 A...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...How to change the FROM field in email campaign activity?
How to change the FROM field in email campaign activity?
I would like to create an email campaign activity and change the TO
field of the email to be abother name instead of mine
I would also like to add attachments
I can't find a way to do this
Any help is very much appreciated
There are many ways to send marketing emails from CRM:
Quick Campaigns with mail merge using Microsoft Word
E-mail Campaign Activities
E-mail Campaign Activities with mail merge using Microsoft Word
Direct e-mail using templates
Send a workflow e-mail
Integrate...Error trying to make an account default
I have a new computer and my outlook 2003 is not letting
me assign a default account to send and receive. I get
this error: "The Specicied Account could not be found. It
might have been deleted."
I have four accounnts setup and have tried removing the
accounts and recreating them and still get the error.
when the account has been made, it tests fine. None of
the four can be made default.
Thanks in Advance!
...Make sales target (quota) invisible for other users
I am setting up a MS CRM system for a pilot which focus primarily on our
I have given each user who's a salesperson given a quota in the CRM system.
These numbers are confidential and so not everybody may be given the
possibility to view this data.
But when I checked with another role, I could see the quota of erverybody
who's got quota assigned.
Is there a possibility to make these quota's only visible to the persons I
want (for example the director can see the quota's of everybody, the
salespersons can only see the quota for themselves and the rest o...Annoying problem with lookup field
On a client, I have a MOSS 2007 portal with two lists which are not
wroking as expected. One contains people and the other one contains a
lookup field based on data from the first list. When someone which
hasn't got administrative rights logs in and tries to see the
properties of any element in the second list (on DispForm.aspx), they
can't see the lookup field value, and if they try to edit the element,
the dropdown control used to choose a person from the first list
appears empty. Administrator don't have this problem.
The users having the problem have collaboration rig...