Duplicate Rows #2
I have exported an Act 6.0 contact database into a .csv excel spreadsheet. It
worked perfect! Each contact occupies a single row. However, some of the
contacts are duplicates (existing before the export). Is there an easy way
that I can remove duplicated rows in a spreadsheet? I know there must be, but
"instauratio" <firstname.lastname@example.org> wrote in message
> I have exported an Act 6.0 contact database into a .csv excel spreadsheet.
> worked perfect! Each contact occupies a singl...Charting Time #2
I have a temperature graph that I need to chart over time. From 0 to 168hrs
but the Log chart in Custom Types gives me even spaces between the times
which is not what I want .25mins to 168 hrs? If I was to plot the graph in
minutes it would be too vast - huge!
Is there any add-ins available to do this type of graph.
No add-ins necessary, just use Excel. You can put your data in decimal hours
if you want, or enter it as hh:mm format. Don't include text labels in the
same cell, or Excel will treat the times as categorical labels. Make an XY
char...Import CONTRACTS into CRM 1.2
Anybody can tell me how can i import contracts into Microsoft CRM???
The data migration framework does not allow this!
Thanks in advance and sorry for my english.
You might try using Scribe Migrate's 90-day license for
importing data into Microsoft CRM.
>Anybody can tell me how can i import contracts into
>The data migration framework does not allow this!
>Thanks in advance and sorry for my english.
Thanks linda, but... what's t...Server Error in '/' Application #2
After meticulously following the installation instructions included
with the MS CRM CD, I have run into the following error that I'm
hoping someone can shed some light on:
Server Error in '/' Application.
Access is denied.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.ApplicationE...Strange characters in Excel #2
A user in my network complains then after working sometime in excel
(10-15 minutes) he starts receiving strange characters when typing, like
if he presses the S key A will be written or some other special
character this at the same time also happens with other keys as well.
other products in Office suit runs ok.
Now when i connect to his workstation remotely i don't face this problem
when typing on his screen via my remote control software (VNC)
what can be the problem ?
See your other post for the reply!
> A user in my network complains the...not enough memory #2
i open a multiple page file and i cannot access other pages
showing a NOT ENOUGH MEMORY message. even though i have
512MB physical memory. what's the solution(s)?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Josh <email@example.com>...
> i open a multiple page file and i cannot access other pages
> showing a NOT ENOUGH MEMORY message. even though i have
> 512MB physical memory. what's the solution(s)?
Are you running Norton AntiVirus?
How much hard drive space do you have?
What size is your swapfile?
Ed Bennett - MVP Microsoft Publi...Summing multiple tables
I am trying to use a query to sum up multiple tables. When run, it should
have like 14 fields with each having a sum total for a table. I have tried
doing this up to 3 tables (took a long while), but it didn't work for 4
tables; I just get a blank observation in the query view. So my questions are
if there is a way to do this for 14 tables and if this will take up a lot of
Since each of these tables is independent of the others, you should be using
14 queries. What is the point of doing the summation in a single query?
If you are doing this for a report or ...Advanced Find #2
The security role has been set so that it read for user.
User can still see records created by other users.
Set the security role on core records so that read is only for userr.
Apply this role to a user.
Do an advanced find.
Find in activities:
Field: Created by
Condition: Does not equal
Type:User (here you should only be able to select the current users)
Enter go and the list of activities for everyone in the whole organization
It is my understanding that this should not occur with the role set with the
core record to user.
I would expect that there be no...Sum of all numbers before a blank row
I have an excel file which i have sorted by column 'Ordered Item'.
Next to this column is a 'Price' column. The 'Ordered Item' Column
may have duplicates. What I need to do is put a subtotal beside each
group of 'Ordered Items' (even if they are single items). How would I
sum the Prices every time there is a change in the data in column
Ordered Items Price
So if the sheet looks like this, how ...Strange Behavior #2
We are running Outlook 2003 on all our desktops, some of them have started
showing the same issue/problem...
When you send an email the outbox stays bold until you click somewhere
else in Outlook.
Does anyone have any idea what is causing this and/or how to fix it?
Thanks in advance,
I can also confirm (just checked) that the mail in outbox isn't being sent
until that click happens.
> Dave" <News> wrote in message news:O6LLG9eKFHA.firstname.lastname@example.org...
> We are running Outlook 2003 on all our desktops, some of them have started
> sho...aligning dates #2
I have dates in the format yyyy mmm dd. If I use a font like Arial the =
days(dd portion) don't line up. How can I align them without using a =
fixed width font; maybe via number formatting codes(just a shot in the =
2004 Sep 01
2004 Jul 01
[Rewrite email id to reply in person]
They sure seem to line up for me.
If you change the zoom factor to 100% does it look ok?
If yes, then maybe this post by Debra Dalgleish will help:
You can change a registry setting to prevent this from happening (make a
backup copy of the registry first):
1. From the Start button, choose Run...auto sum will not work
I am new.. I did the tutorials.. I have a new spread sheet and I can not get
the auto sum to work. I highlight my column and hit auto sum and it gives me
a formula but no total. I pushed enter but I can not figure this out. I'm a
Please help me.
Sounds like the cell if formatted as TEXT. Change the cells format to
GENERAL then hit function key F2 then hit Enter.
Microsoft Excel MVP
"Soshagayle" <Soshagayle@discussions.microsoft.com> wrote in message
>I am new.. I did t...Intelligent Message Filter ver 2. Not sure if its enabled or even installed correctly.
I recently upgraded to Exchange 2003 SP2. Before doing this I uninstalled
IMF ver 1 as instructed. How can I check whether IMF ver 2 was installed
correctly with the SP2 and running properly? There is no longer anything in
the SMTP protocols in Exchange System Manager that says Instant Message
Filter, although there is still the IMF tab in the Message Delivery.
Is it possible that the IMF ver2 didn't install with SP2? How can I install
and enable it? The only reference I can seem to find refers to ver1.
Many thanks in advance.
"Barry Johns" <email@example.com&...Can't operate 2 separate Office 2004 programs within same network at the same time
Operating System: Mac OS X 10.4 (Tiger)
We have 2 macs networked. Each has its own software of 2004 Office (we just bought and downloaded the second version for the second computer to fix this problem) but the computers will not allow 2 people to work on their computers using the 2 programs. It says someone is already using the program and will not allow the other to access their own version. One computer has both versions, one computer has only the newer purchased version. How can we make this work?? Any help will be appreciated so we can get our work done! Thanks. Victoria
&l...20 Amazing Beautiful Landscape Wallpapers Set 2.exe (7/7)
=ybegin part=7 line=128 size=1593867 name=20 Amazing Beautiful Landscape Wallpapers Set 2.exe
=ypart begin=1497601 end=1593867
��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n�...2 bars, 2 axis??
I'm trying to create a graph which shows load factor (one bar) and yield (one
bar)for the month, then next to this the same data for the next month and so
I can create the graph and assign each of the bars to the primary or
secondary axis. However this causes one of the bars to sit on top of the
other, I want them to sit side by side.
Any idea's please?
For a 2 series column chart with a series on each y axis try Jon's example.
> I'm trying to create a graph which shows ...Investment Summary on Home Page #2
My investment summary on my Home Page shows some stocks I haven't had for
years, and is missing some that I currently own. How can I choose what to
I just noticed the same thing on my Investment Summary. My Portfolio
manager is correct, but the Investment Summary is out of date. Any help out
"David Schwartz" <firstname.lastname@example.org> wrote in message
> My investment summary on my Home Page shows some stocks I haven't had for
> years, and is missing some that I c...Re:Gord Dibben Sum Text
It works fine writing text in B1, thank you!
Now, I've tried to write the text in A1, but then I get that ###value
Please explain how this formula works, so I can modify it as I wan
(In my version of excel I have to write ; instead of ,)
Jonsson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=547
View this thread: http://www.excelforum.com/showthread.php?threadid=27548
(remove nothere from the ...Money has stopped working #2
I receive error: Money has stopped working when I try to backup. A
search found kb942485 which suggests changing DEP settings. Article is
for Vista, won't let me make changes running Windows 7 Ultimate.
Money Deluxe has run fine until last few days, problem started after
installing newest updates, including Live Essentials 2011. System
Restore is out, too many changes since updates were installed.
Any suggestions greatly appreciated.
In microsoft.public.money, No_Junk_Wanted@Here.com wrote:
>I receive error: Money has stopped working when I try to backup. A
>se...Linking workbooks #2
Hi, I have two workbooks, exactly the same, on two different computers
and both have to be updated. Updating takes place by two different
people. My problem is that when I try to update the one on the other
computer, the user has left it on and I get a read only file and vice
versa when he tries to update mine.
We both need this file at varying times of the day, sometimes at the
same time. Is there anyway that I can link these two files so that as I
input data or he inputs data, both files are updated?
I am not sure from your comments whether you have one file accessible from
two...worksheet tabs #2
How do you switch between worksheet tabs using the
Use CTRL+PageUp and CTRL+PageDown.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"llh" <email@example.com> wrote in message
> How do you switch between worksheet tabs using the
In Excel, go to Help and Look at Keyboard Shortcuts
"llh" <firstname.lastname@example.org> wrote in message
: How do you switch bet...Frank Kabel #2
I have a doubt that no one can take it off and i'm around and around the
problem and because of a part i can't solve it.
This is the problem:
A B C D
Prod. Stock In Out
Wine 10 3 6
Fish 13 2 1
What i want to do is to identify the product that has move quantity in or
out such as quantity that has been moved, once i solve this problem i think i
can do the rest of problem.
Can you help me???
Thank you very much!!!
not really sure what you mean by 'move quantity'. In your example what
would be yo...Server side rule #2
How do i go about creating a server side rule? Im trying to foward email to a
blackberry so if you have any help it would be appreciated
On Tue, 16 Aug 2005 11:48:43 -0700, "Ap"
>How do i go about creating a server side rule? Im trying to foward email to a
>blackberry so if you have any help it would be appreciated
A server side rule is merely a rule that you create in Outlook that is
able to process without a client running because it's got all the
components it needs to fire that rule on the server configuration.
As for th...deleted 2 columns by mistake
I have deleted 2 columns of info and have saved - is there anything I can do
Only if you're on a company network or suchlike that backs it up, otherwise
if you overwrite the file, that's it I'm afraid,
"Lang8er" <Lang8er@discussions.microsoft.com> wrote in message
>I have deleted 2 columns of info and have saved - is there anything I can
> ! argh!
scream & yell?
"Lang8er" <Lang8er@discussions.microsoft.com> wrote in message
news:32D9...CRM 1.2 Security Service will not start
This morning I am having an interesting error. Security Service did not start
after reboot. When I tried to start it manually, an error appeared:
Could not start the Microsoft CRM Security Service service on Local Computer.
Error 1053: The service did not respond to the start or control request in a
I have no descriptive error in the Event Log.
I see you posted this yesterday, have you been able to get the service
started since then? If not, what account do you have the service set to start
under? Has the account changed since installation? If so, make sure that ...