Comparing 2 series of data
I have a question regarding scatter (XY) charts on Excel
2000. I have 2 series of data that I want to compare
with one another. I have plotted both series of data on
a scatter (XY) chart in order to compare the 2 series in
terms of the relationship between variables, X and Y. In
addition, I have included a 2nd order polynomial
trendline for each series so that the graph contains 2
trendlines (one for each data series). I want to know if
there's a way for me to compare these 2 series of data
(possibly using slopes of the trendlines) and obtain p
values and confidence in...How do I link Excel pages to a different master Excel workbook?
I am trying to take part lists from different assemblies and link them to a
master part list. Ideally one sheet from the assembly part lists will have
many pages and be linked to a sheet in the master part list with the name of
that specific assembly.
I am operating on Midrosoft Office Version 2003.
open both the master and your part list on your master if you set a cell to
(="name of part list book"!A1) you can do that by clicking any cell on the
other workbook with them both open its just like a formula on the sheet only
instead it has the workbooks name first i hope thi...Please quote.dot for 1.2 its really urgent
...Cannot connect outlook 2007 to exchange 2003 via LAN #2
I got a new laptop for work running Vista and outlook 2007 and no matter how
many times I tried setting it up to connect to the exchange server 2003, I
always get the message that outlook is not connected and it needs to be
connected to complete this action....
I used to have a laptop running XP and outlook 2003 and it worked fine with
the same mailbox settings.
Any ideas please?
Can I use VLOOKUP to look up data in a data base and total multiple
values associated with the lookup number in a range?
Result #700= $950
Message posted from http://www.ExcelForum.com/
Vlookup is not the tool to use here.
Try using SUMIF, it will fit the task nicely. (Also look at COUNTIF,
DSUM for similar functions)
Message posted from http://www.ExcelForum.com/
As Kieran says, try SUMIF instead of VLOOKUP
Here's some steps to ease you-in on using ...CStatic #2
How can I resize CStatic (Picture) in the design time?
Assign an ID to your static control, other than the default IDC_STATIC
id. Say IDC_MYPICTURE.
Now associated a member variable of type CStatic control, to this ID
using the class wizard. Say m_MyPicture.
Finally call m_MyPicture.MoveWindow(..) in order to resize the control.
Check Abdoul [VC++ MVP]
"Oliver Young" <none> wrote in message
> How can I resize CStatic (Picture) in the design time?
...Money 2003 Deluxe
When I go to Reports/Taxes/Tax Software Report I get a summary of what
should be included in the various Federal Tax Forms. Everything looks
reasonable except for the Capital Gains and Losses Money generated when I
bought or sold a stock. It looks like some of the transactions ended up
under Schedule C! Can someone give me a hint on where I have to go to tell
Money how to handle the generated gains and losses? I have been to all the
obvious places like "Catagories" and "Taxes" but I must be missing
something. Thanks in advance.
In microsoft.public.money, Ken wrote:...how do i merge 2 rows of data into one
I am trying to combine data from 2 rows so that i can use the data as one row
which will enable me to sort the data accordingly.
you may provide some more details how your data is structured and how
you want to combine it
"willid" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I am trying to combine data from 2 rows so that i can use the data as
> which will enable me to sort the data accordingly.
You can't merge data without losing parts ...downloaded transactions
How can I "fix" downloaded transactions that aren't
there? I've downloaded my statements, they are imported
into the account, Money tells me how many I need to
review, but they aren't there as they usually are
(bolded). I have tried to "accept all", to no avail.
Try the following article:
"bartley" <email@example.com> wrote in message
> How can I "fix" downloaded transactions that aren...House Selling Transaction?
I have a house as an asset account in Microsoft Money. How do I create a
*sell* transaction for the house? I sold my house and want to show that
Well, you could "decrease" the asset to zero but my preference would be to
"transfer" the money you received to whatever bank account is appropriate.
"Refresher" <Refresher@discussions.microsoft.com> wrote in message
> I have a house as an asset account in Microsoft Money. How do I creat...GL Year End Closing #2
After we ran the GL year end close the Year End Closing Report does not
balance. Also the retained earnings amount is incorrect. I checked and all of
the P&L accounts have a beginning balance of zero.
Has anyone run into this and how can I find what accounts are off and
Have you checked your GL Trial Balance for the new year to see if it
balances and the correct RE balance is reflected? If it does, maybe
there's a problem with the Year End Closing Report itself.
If your new GLTB doesn't balance the first thing I would do is start
compar...Transaction which is part expense, part transfer
I have a debit from an account associated with arranging a remortgage
on a house. Part of the sum debited is a payment of legal expenses, so
it belongs in the "mortgage expenses" category. Part of it is a sum
which was used to reduced the amount of the sum owed to the lender.
Any suggestions for how to deal with this? The loan reduction element
is effectively a transfer to the loan account, but the "split"
dialogue box only allows you to allocate a "withdrawal" to different
categories, it doesn't let you split an amount between a withdrawal
and a transfer.
Go...DATE Formulas #2
I wrote last time:
I want to know what I will get paid TODAY, THIS WEEK or by the
I don't know how to get the Day (C2),Week (D2) and Month.(E2).
Thanks for those who helped.
I must add that if today is Thursday I need to know what I will get paid
Thursday - Saturday for the week and from the 29th - 30th of the month. In
other words for the week and Month calculations it must be going forward
from the current day not for the entire week or month if that time has past.
If the weekday is Tuesday then I need from Tuesday to Saturday. What formula
can I use to accomplish this...OE blocks attachments #2
I cant open my attachments (word) it says *OE remove
acces to unsafe attachments*..and I know for a fact its
not an unsafe document. What would be the problem? And
what is OE ??
Thanks for helping.
"Christine" <firstname.lastname@example.org> wrote in message
> I cant open my attachments (word) it says *OE remove
> acces to unsafe attachments*..and I know for a fact its
> not an unsafe document. What would be the problem?
Tools-Options-Security for the 150,000th time. Did you not do ANY research
AT ALL before ...Shortcut for copying formulas referencing different worksheets
I am looking for a shortcut. I am copying the same forumula from Row 1
down the page, but where Row 1 references the next worksheet, Row 2
references the following worksheet, and so on. Is there an easy way to
do this without having to go to each worksheet, find the cell and click
on it? TIA
bhigdon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23686
View this thread: http://www.excelforum.com/s...Have E-mails available in 2 Locations to View
Is it possible (and easy) to configure 2 PC's to have the same e-mails?
What I'm think of, instead of synchronizing via a memory stick that I would
share out the "Outlook.pst" file which would be located on PC-1 in
Location-1 over our network, then when I am in my remote location, my PC-2
in location-2 will look at this "Outlook.pst" file, thus having the same
e-mails and not duplicates.
We don't run Windows server just stand alone PC on a peer-to-peer network.
Would what I have detailed above work? I'm just assuming that you can't have
both PC...Upgrade from 1.2 to 2.0
My RMS reseller upgraded me from 1.2 to 2.0.
After doing so, none of my matrices work due to the fact that attributes and
codes are not in the matrix dimensions.
I have lost all customer purchase history, but I do have the totals they
I have lost all my purchase orders.
They installed SQL express.
I can not connect to either of my stores through HQ.
Am I with the wrong reseller?
Can someone help?
Ouch- That has got to hurt- If I lost that Data, I would want to strangle
"lax guy" <email@example.com> wrote in message
news:EDEE3830-4C03-4778-...working from 2 pc's
is there a convenient way to use a single money file from two different
pcs? I bought money small business, in order to run my business as well as
my home accounts. however, I also have an office space outside the home,
and have need to create invoices from that location. Of course, I don't
want to create the invoices in two different places.
Someone here recently posted that they use an external hard drive, and that
a USB memory device works as well. I'd think that would be the ideal way to
do it. Other than that, it would be difficult to keep them in s...2 copies coming into Inbox
I recently paid for a hotmail account so I could have
larger storage and not get cancelled for any reasons such
as not checking it often enough. I followed the
instructions and put my service on Outlook Express. Now
I'm receiving 2 of every message. What's up?
Can I fix this?
...cost of Inventory at a past date...? In RMS 2.0
Does anyone figured out a way of knowing what the invntory was on Dec 31
I can't find a report that would give me that info.
This is a multi-part message in MIME format.
Check with Ryan @ RITE firstname.lastname@example.org as they have a custom report. =
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D...Consolidate Data #2
I'm looking to the experts on this one as I'm a very basic VBA user
and not sure where to start. I'm looking for some help in buildig a
macro that could do the following. Take a column of data such as below
and then Consolidate the data 50 cells at a time with the data
seperated by a semi-colon(no spaces) into 1 cell. For Instance:
I'm sure there's a way to do it. I'll be honest. I have ...Preserving lock on cells even when copied and pasted within a sheet
(Sorry for repeating this post from another group; I inadvertently
neglected adding both groups in my original post in
microsoft.public.excel.misc. In any case, I found a couple of minor
errors and omissions that I have corrected :-P.)
I am trying to create a *protected* worksheet that is flexible enough
so that additional rows can be created (by copying existing rows from
above) if additional data becomes available to be entered. Locking
rows with formulas and protecting the sheet does allow the user to copy
and paste the cells or rows (most often accomplished by dragging by the
handl..."update ta set ta.ra=1 from tablename ta" how can pass in Access
is it can be pass in the Access?
how to change?
set col = t.col
from ta,(select id,max(col) col from tb
group by id) t
where ta.id = t.id
UPDATE ta SET col = DMAX("col" , "tb", "id=" & id )
UPDATE ta INNER JOIN tb ON ta.id=tb.id
SET ta.col = tb.col
WHERE tb.col = ( SELECT MAX(col) FROM tb AS c WHERE c.id = ta.id )
A Jet query implying an aggregate (elsewhere than in a sub-query in the
WHERE clause) is NOT upd...VBA unter Office v. X
ich versuche gerade ein VBA-projekt an MacOS X anzupassen, aber ich kann
keine Dokumentation oder Beispiele f�r DECLARE unter MacOS X finden!
Konkret m�chte ich die Rainbow Sentinel API auf diese Weise ansprechen, aber
ich konnte bisher noch nicht einmal herausfinden, welche Libraries Word
�berhaupt unterst�tzt, und wie die entry points zu deklarieren sind.
Ich w�rde mich �ber jeden Tipp freuen.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Sascha Ren� Leib - KOPFteam GmbH - http://www.kopfteam.de/
"There is not, and will...Top 3 within a group
I have a table of student ID's (numeric) courses and marks such as
shown in this example:
ID Course Mark
123456 Math 11 80
123456 English 11 82
123456 Socials 11 75
123456 Science 11 92
123456 Geog 11 84
123456 Physics 11 70
234567 Math 12 65
234567 English 12 71
234567 Chem 12 60
234567 Geog 12 88
234567 Phys 12 70
I want to produce a list that shows the top 3 courses for each
ID Course Ma...