formula question #3
I am using the following fomula
the formulas works great, however in trying to copy the formula, it adds a
number to the list values and looks like this.
the list I am wanting to work with starts at aa1 and ends at aa113, so this
will not work.
I do not want to edit the formula in each cell, as I am wanting to fill
acouple thousand cells.
You need to add more dollars.
...create multiple scatterplot from 3 columns
Is it possible to create a scatterplot with multiple series (>2) from a
dataset with 3 columns:
group X Y
A 1,9 9,6
B 9,9 3,6
A 8,3 8,4
B 7,7 5,8
B 6,9 0,8
C 6,8 7,3
C 8,2 8
D 6,8 4,5
D 3,1 5,3
E 3,3 5,9
The firts column defines the group (each group has a different symbol), the
second and third define the X and Y coordinates. My dataset contains about
400 lines and has 15 groups, which is too much work to copy the XY from each
group to different columns. I'm working in Excel 2003.
You cannot use this data to make a chart. You need to separate the X and Y...Timesheet #3
Can anyone point me to a free excel working timesheet to record employee
Chip Pearson has a timesheet download that will probably do what you want.
Gord Dibben MS Excel MVP
On Wed, 5 Dec 2007 19:35:11 -0000, "JM" <email@example.com> wrote:
>Can anyone point me to a free excel working timesheet to record employee
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:oq0el3dhltljhe8nmc14...Text boxes #3
How do I group text boxes?
Karen M <Karen M@discussions.microsoft.com> was very recently heard to
> How do I group text boxes?
Select two text boxes, Ctrl-Shift-G.
To select multiple text boxes, you may need to follow this procedure:
You will need to select the text box itself, not the text within. To do
this, the easiest way is to go into the text so you get a flashing insertion
point |, and then click the hatched border around the text box. The
consistency of the border will change and the insertion point | will
disappear. One text box is now selected.
Now, hold Shi...Mail Merge #3
When I try to do a mail merge of about 500 emails the
system stops sending sometimes after 250 or so and then
sometimes it will stop sending after just a few. I have
been able to shut down the system and start up again and
the emails would start back up but only briefly. The
size of the HTML formated email is only 24K.
...need query to random update field with 0,1,2,3 or 4
Hi, I need to update a field with a random number 0 1 2 3 or 4 in order to
test a report. Can anyone set me up with a query for this? There is no
criteria to update from, it should update all records in the table.
On Tue, 7 Aug 2007 12:06:30 -0700, "Rob" <firstname.lastname@example.org> wrote:
>Hi, I need to update a field with a random number 0 1 2 3 or 4 in order to
>test a report. Can anyone set me up with a query for this? There is no
>criteria to update from, it should update all records in the table.
SE...Delete mailbox #3
I have Exchange 5.5 server running 1000 users.
I wanted to delete 500 (mailbox and user account) of them. How do I delete
them using template?
It's not practical if we delete them one by one.
Any idea or reference website I can read?
"Muhamad Taufik Khasim" <Taufik@uniten.edu.my> wrote in
> I wanted to delete 500 (mailbox and user account) of them. How do I
> delete them using template?
> It's not practical if we delete them one by one.
Here is some good information for you:
http://support...Flexible spending account #2
how do i track flexible spending accounts like health-
care/dependent care spending accounts?
I do it by setting up an account, type cash, name Flexible Spending.
"venkmon" <email@example.com> wrote in message
how do i track flexible spending accounts like health-
care/dependent care spending accounts?
Transfer money into this account from your paycheck deduct. Transfer money
out of this account to, say, your checking account when you draw
"Kent Riesen" <Kent Riesen...Outlook vs. Outlook Express #3
I have XP Professional on my Dell Laptop and Outlook
Express. Am I supposed to have Outlook (and not
express)? How do I upgrade to Outlook from Outlook
You buy it as part of an office package. Outlook express
comes with Internet Explorer which comes with all Windows
>I have XP Professional on my Dell Laptop and Outlook
>Express. Am I supposed to have Outlook (and not
>express)? How do I upgrade to Outlook from Outlook
...XmlTextReader Question #3
I am parsing a xml string for a specific element using XmlTextReader (code
below). I now need to change it to get the element's value plus get the
parent node's name. Can someone help me?
public object GetResponseValue(string xml, string element)
using (XmlTextReader reader = new XmlTextReader(new
object elementValue = null;
object elementTag = reader.NameTable.Add(element);
if (reader.NodeType == XmlNodeType.Element)
elementValue = reader.ReadElementContentAsObject();
b...E-mail Preview Programs #3
I use two e-mail preview programs - they both are not 100% accurate although
they used to be. I receive � 100 messages per day. (I've been using PCs
since the early '90s and was not careful at first 'cause I didn't know
better.) Luckily, the preview programs make it easy to delete junk.
The first program is MailWasher Pro. The second is not really a program but
a web site: that of Adelphia, my ISP. My e-mail program is MS Outlook.
Let's say a preview program indicates that I have 60 e-mail messages. I
delete 50 of them, leaving me 10 messages. Then I download the remainin...Favorite Folders #3
I am using Outlook 2003.
I don't need this function, but it lists my Inbox & Sent Items folders right
above my All Mail Folders.
How do I remove Favorite Folders from being viewed?
Rick <Rick@nospam.com> wrote:
> I am using Outlook 2003.
> I don't need this function, but it lists my Inbox & Sent Items
> folders right above my All Mail Folders.
> How do I remove Favorite Folders from being viewed?
You can't remove it completely, but you can remove the folders in the
Favorites section. RIght-click and choose "Remove from Favorites Folder...Spending Tracker not tracking
Upgraded to Money Plus Deluxe couple months back. The Spending Tracker is
not registering certain categories so it doesn't keep up to date with my
budgeted amounts. I've checked that the accounts are included in the budget
and Spending Tracker. Anyone have this problem and how were you able to
One one else have this problem?? I guess it's just my luck.
"Don" <firstname.lastname@example.org> wrote in message
> Upgraded to Money Plus Deluxe couple months back. The Spending Tracker is
> not re...Threads #3
till now I have used timers, but I want to change my programme to use
I know that one timer routine sometimes crashes and ends my programme.
I don't know threads very well, so I have these questions:
1. If a thread crashes, does the whole programme crash too, or do the other
threads still work?
2. If they still continue working: Is there a possibility to recognize that
the thread has crashed so that I can restart it?
Thanks for help,
yes, if you have access violations,null pointer access and other unhandled
exceptions in the thread,
your program would...DAO 3.51 vs. DAO 3.6
Having trouble with a corruption in an Access 97 database, I followed some
advice to convert it to Access 2002, repair and compact it and then convert
it back to Access 97. All this worked fine and it seemed to help. However,
it replaced the DAO 3.51 reference with DAO 3.6. This works fine on my PC.
1. Is this supposed to work? I thought 3.6 was designed to work with Jet 4
which is not what Access 97 is.
2. If it is supposed to work, I may want to use it when I upgrade the
client who uses this system. However, they don't have any Microsoft
applications that would hav...y error bars #3
On a chart, is there a way to have different colored y error bars?
I am using the minus and custom range for parameters on the y error bars
thanks for any help
Error bars are formatted by series: all X error bars for a series can be
one color, and all Y error bars can be another. You can always add an
invisible series for each different color error bars you want.
Peltier Technical Services, Inc.
> On a chart, is there a way to have different colored y error bars?
> I am using the minus and custom ...Spending Tracker
i have a sub category that always displays in the spending tracker. even if
i remove all categories from the list, this one category still shows up.
it's not even on the list which is another question - what makes a category
show up on the list ? they are not all there.
...Gift Cards #3
I am looking to create gift cards. Cards that customers can buy as gifts, add
any amount of credit on them. I would like wither bar code or magnetic
swipe. Is this possible to do without having to use the cervice of an
outside company (beyond making the cards)?
Yes it is called vouchers. Built in to RMS can be used with barcodes as well
as mag stripe.
"Willie" <Willie@discussions.microsoft.com> wrote in message
>I am looking to create gift cards. Cards that customers can buy as gifts,
> any amoun...excel solver #3
how can i have the solver on excel ?
The Solver is an add-in. To see if it's available goto
Tools>Add-Ins. If it's in the list that appears click in
the ckbox then select OK. If it's not in the list, then
you will have to install it from the original distribution
disk. You can do this in Add/Remove Programs.
>how can i have the solver on excel ?
Help! For some reason or another I can't figure it out, I
lost my spending thermometer on a budget item. It shows up
in the budget as having a budget amount but when I enter
in a transaction it says I have a budget amount of zero
and to enter a spending limit. When I go into
thermometers its says budget amount is zero and I can't
change it. Any ideas?
...CRM 3.0 for current customer...when do I get this?
I have an active service agreement, but still haven't received CRM 3.0, even
though I've read here that it shipped December 6. Also, it's not available
for download from Customer Source and we're still listed as being licensed
for 1.2 only.
Can anyone please explain the process for acquiring 3.0?
It depends on the type of Software Assurance you own (Enterprise licensees
will receive the upgrade license and media automatically), but most SA
licensees will have to ask their MBS reseller to order the license keys and
media, for a nominal fee (shipping and hand...Undeliverable #3
I am running SBS 2000 SP4 and I have certain users who's
addresses come back as undeliverable unless you fully
complete their addresses when typing (not auto-complete).
Let's say Our email server (hosted by our ISP) is
Our domain on SBS running Exchange is named 'thisdomain'.
When I look at their profilesand email address settings
they seem to be identical to the other users who
experience no problems. However, when I export the address
book into Excel and scroll to the EmailAddress field they
show this type of address-
'/o=thisdomain/ou...news groups #3
I used to be able to view news groups from outlook (2003). Recently though,
the icon for the newsgroups has disappeared from my menu. I have followed
microsofts guide (see below) to put it back on the menu but the icon does
not exist in the go menu, nor any of the other menus.
On the Standard toolbar (toolbar: A bar with buttons and options that you
use to carry out commands. To display a toolbar, press ALT and then
SHIFT+F10.), click the Toolbar Options arrow .
1.. Point to Add or Remove Buttons, and then click Customize.
2.. Click the Commands tab.
3.. In the Categories list,...How to categorize non essential spending?
I'd like to set a budget on what I can spend for "want" vs. "need"
items. For example, utilities, gasoline, phone are "need". A new
camera, book, chair are "want". I currently categorize all of these
but I cannot run a report such as "Wants" and see all non essential
spending for that month and know where I stand against a budget.
Should I just create two large categories called Needs and Wants then
start adding existing categories to them? Both will be expenses.
To take it a little further, I'd like to setup some type of bank
I have two accounts at my brokers. The one is an IRA. The other is a
checking account that also hold investments. What type of account do I use
that will handle both a checking account and an investments in the same
It would be better to read answers than to keep posting the same question.
Just a thought.
"Len Urban" <LTUrban@gte.net> wrote in message
>I have two accounts at my brokers. The one is an IRA. The other is a
>checking account that also hold investments. What type of account do I use