Trying to find out which numbers occure most often
I�m giving exams to students and want to see if the students are missin
the same questions in every class. I have a simple spreadsheet tha
has me enter the question number into the column each time a questio
is missed. The MODE function can tell me which number is occurrin
most often. However, I need to see if there is any other numbers tha
are occurring often as well.
Is there a command that will allow me to look at the second mos
entered number? For example, if I have 5,3,3,2,3,4,3,4,1,3,4, my mod
would be 3 as that�s the number that repeats the most. However,
happens 3 times and that...Crash on 'Send"
My wife's Intel Celeron running ME started having this problem
sporadically - now constantly.
Outlook 2000 receives OK - everything seems fine until you hit the 'Send'
button then Outlook crashes giving an error message that says 'Outlook has
caused an error in <unknown> and has to shut down. If the problem persists
you may have to restart your computer.'
Re-starting however has no effect.
I have re-installed Office. Used 'Detect & Repair' under the 'Help' tab, and
installed all patches/updates from the Office site. But this error
continues, now...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...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: <**...Unlocking a User
I have GP10 and a user entered a password wrong too many times. I am logged
into GP and an under 'Admininstration' and do not see a way to unlock the
user. Am I in the right place? Where do I need to go?
Are you enforcing password policies for your users in GP? If so, go to
Microsoft Dynamics GP > Tools > Setup > System > User. Enter a temporary
password for the user and check the Change Password Next Login box. Provide
the user with the temporary password and the system will do the rest.
Again, this is all assuming your are enforcing pas...Recieve Mail Before Sending
How do I set up Outlook 2003 to recieve mail before sending
Set your send/receive group settings to receive and not send. Or are you
talking about setting authentication?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Keith <email@example.com> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I
want to show hourly sales for the month of October so I can graph it and
post it in our break room.
If I can't export hourly data, can I export daily sales?
The built-in reports don't address this data format.
This is a multi-part message in MIME format.
Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to
load...Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one
whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way
to fix this?
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
...cant start outlook pst file to large
Hi I hope somebody may be able to help im new to outlook and now I cant start
outlook message says cannot open your default email folders pst file its too
large as I cannot open outlook I cannot delete old folders
See if this helps: http://support.microsoft.com/kb/296088
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Ray" <Ray@discussions.microsoft.com> wrote in message
news:B3B824DC-3C9B-4B1B-8EF3-61...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...help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter.
It is stuff like 2+2 =4
Smart me has hit a problem at the first hurdle...
I need to put 2 in one cell the + in another cell and then 2 in another = in
another and then she puts the answer in the next one. So the above would
have 4 cells completed and she would put the answer in the 5th one.
When I use the + or = sign in a cell of its own it (excel) thinks I am doing
an equation, is there a way around this?
I will work on the answer like if she gets it correct or wrong how I will do
that...a sound or som...Find prev record on other requeried form
Using access 2003. I have a main form for name and address info. A subform
shows limited info on client placement.
Click a command button on the main form and user opens another form for full
screen entry of placement data. That form opens showing the client selected
on the initial main form.
When the full screen placement form closes, it requeries the original main
form with the placement subform to show the added placement. It goes to the
first record in the table though. It does not show the original client whose
placement was just added.
How do I set the mai...Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a
"Subtotal" function to count certian rows when I filter the column. My
question is this. Is there a way to save or freeze the data that the
subtotal function counts in a different cell. In other words I want subtotal
to count everything in a particular column but I want to be able to save that
number somewhere so that when I filter again with another variable I am able
to still view the first subtotal to compare the two. I hope this makes
sense and thanks in advance for any assistance you can provi...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 ...Can anyone help ?
I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...Help with a simple database
I am attempting to use Excel to develop a simple database for my office.
The database basically lists a variety of orders purchased from various
vendors, and my goal is to categorize and sort each vendor seperately.
GC Group 4/24/03 7831.1 $1,000.00
Alpha 1/20/03 7003.1 $2,000.00
Chandler 5/6/03 7050.1 $345.50
Is what the main chart looks like. Now, what I'm trying to accomplish
is, suppose I added
Tomsen 4/20/03 7873.1 $200.00
to the very bottom, Excel would automatically create a new tab (or even
worksheet, if possible) tit...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...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...Looking for help on timing within a function
At the facility I work, our associates use a very basic access database to
sign out individual work orders on an interval of around every 12 minutes.
They have asked if it would be possible to put a timer on the front page of
the database to show how long they have been working on the current work
order, updating each time they sing out another order.
I am not very adept at access nor is the rest of our management staff. Is it
possible to add this function, so they can better keep time of their work
Use the Form Timer event. Here is an example of how it can be done. In this
ex...Need Query Help
I have two tables, Table A & Table B, in my database that have the
same fields (Name, SSN, etc). Most of the records in both tables are
identical, but each table has some unique records. I would like to run
a query that will select the unique records in Table A by comparing
SSNs, and then do the same for Table B.
I am a database novice, and have tried all the wizards and expression
builders with no luck.
Any help at all would be appreciated. Thank you!!!
Casa Grande, AZ
The "Find Unmatched Query Wizard" is what you need. If you only want to
check for SSNs ...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...Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
I don't know why you're having this problem but I would like to point
something out for w...Amount of time between dates
My last post gave me a super quick answer to what I couldn't figure
out after days and days of personal searching and trial and error.
What a great user group! Got another question that I hope is fairly
straight forward, but it is a new area to me, dealing with dates.
Basically, the very first column contains dates. To be precise, they
are the dates of stock market transactions. For the past six months,
I have been estimating that there have been 252 trading days a year,
and then figuring out annual returns and such by dividing, let's say,
834 tradings days by 252, so ...Please Help w/ Large Excel File
Hello everyone. I have this Excel file that has drawing text box objects in
the document. When I delete a text box the attributes still are present,
but just not showing. It is continually growing my file size. When I
export the document to HTML after deleting all the text box drawing objects
and saving the file, the text box objects still show as vtextbox elements in
this file. I tried to reproduce this with a new Excel workbook but could
not. I would be greatful if anyone can figure this out, as I have a lot of
documents to re-create if there is no solution. Thank you.