Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
>...synchiing two computers?
Is there a way to synch Outlook on two computers?
I end up with some email on my laptop and some on my desktop - it would be
nice if the two could be synched so that I could have all of my email on
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Bill Andersen asked:
| Is there a way to synch Outlook on two computers?
| I end up with some...Unable to view some Excel files on Network
I am running Office 97 Pro on a Windows 98 Workstation on a Novel
network. We have applied all the patches that we know of to bot
Office and Windows 98. Upon roll out the user notified me that sh
cant get into a certain file for her to do her jobI have uninstalle
Office and rebuilt this machine and still get an illegal operation
error. The error says "EXCEL caused an invalid page fault in modul
EXCEL.EXE at 016f:30002924". No-one including network administrator
can access certain Excel documents that are stored on the network fro
a certain computer but other documents are fine. I...Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to
bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an
example of text.
Col A Col B
Col A Col B
So, what I want to do is say in File 1 take cells A1 and B1 compare them to
File 2 and search Col A and Col B and if there is an exact mat...Unable to download into Money Delux 2004
I had my Money 2004 working properly, so that downloads in
Money OFX format from my bank would automatically trigger
the function in Money that prompted me to import the file.
However, for some reason, this has now stopped working.
When I am in my bank's website, and click on the download
to Money option, it flashes what appears to be the
download window, and then completes, but a) never gives me
the file save/open option and b) Money sits quietly
running in the background and does not recognize a file
waiting for its attention.
Does anyone have any idea how I go about fixing thi...UK shares update but US ones do not
I have V17 of US Money Plus. All my shares in my UK broker accounts update
okay with the online updates. But I have two shares in US accounts (US:IVV,
US:BRK) that do not update.
I'm wondering if the online update only works in one region? Would be
grateful if someone could confirm this.
In microsoft.public.money, ouroboros wrote:
>I have V17 of US Money Plus. All my shares in my UK broker accounts update
>okay with the online updates. But I have two shares in US accounts (US:IVV,
>US:BRK) that do not update.
Bad symbols for ...How to Model IRA Withdrawals in Money 2004 Lifetime planner
I'm planning to setup a scheduled withdrawal from my IRA. I'd like to
model the affects of this plan in the Lifetime Planner. How can this be
done? I only see how Money withdraws from IRA after all tax-paid
savings are liquidated. That's ok as a scenerio, but I'm trying to
force a withdrawal. Possible?
I don't see a way to do this.
"Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
> I'm planning to setup a scheduled withdrawal from my IRA. I'd like to
> model the ...Error message when joining a new computer/user
I am working on Exchange 5.5. All current users can log in, send and recieve
email. However, when I try to install a current user on a newly reformatted
machine or even to join any user to an existing machine I get the folowing
The name could not be resolved. The Microsoft Exchange book was unable to
log on to the Microsoft Exchange server computer. Contact your system
adminstrator if the problem persists
This happens at every station now. Does anyone have any ideas as to what
could be causing this?
Thanks in advance for any help
...Try to move Exch db files, then store doesn't get mounted anymore
any idea on how to solve the problem below ?
I've done these steps in several servers, but one particular server/system
fails to get the Mailbox and Public Folder Stores mounted after moving the
database files from one partition to the other.
I stopped the Public Folder Store.
I click the respective restore, "Properties", I go to "database" tab. There
I inform location of where I want to move the database files to (E:\program
files\Exchsrvr\mdbdata). I've got the message that files have been moved OK.
Then I attempt to mount store, a...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...Attaching a word file to a ppt. presentation
Is there a way to attach a word file to Power Point when in presentation mode
via a company share point site?
...Money 2002 Capacity
Money 2002 was included with a new computer purchase of
mine. I am not at all familiar with it at this time. I
want to use something to track the account of a "CLUB"
that will include individual accounts within the main
account. Is Money 2002 a good program to use or should I
be looking into a custom database?
> Money 2002 was included with a new computer purchase of
> mine. I am not at all familiar with it at this time. I
> want to use something to track the account of a "CLUB"
> that will include individual accounts within the main
> account. Is Money...Saving as PDF file
I am trying to convert an excel spreadsheet into a PDF
file, what is the easiest way to accomplish this?
Purchase Adobe Acrobat, install it, and press a button.
Once you have Acrobat, the rest is very easy.
"Brian" <Brian.Moddelmog@williams.com> wrote in message
> I am trying to convert an excel spreadsheet into a PDF
> file, what is the easiest way to accomplish this?
If you search about 5-20 messages down from yours, you will see the exact
same question being asked. You can get more answers...Mora than one Domain Exchange 2003
Hello! i have instaled an exchange 2003 and i need to use two domain, so the
first domain works fine but now i need to use one of the user with another
domain. Before this exchange 2003 i was running exchange 5.5 with both
domains without any problems. Pls can anybody help me?
Hi! Yes, the user that use the second domain needs that domain (the second)
to be their primary (in fact the only) email adress.
"PhilE" <email@example.com> escribi� en el mensaje
> Does...COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names. Column C has project unit status -
'pending', 'beta' or 'completed'.
It's easy to set up a formula to count how many units are allocated to
each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is
set up formulas to count how many units Joe has completed, or has
pending or at beta, and this means assessing data in both columns -
which COUNTIF won't do.
This doesn't strike me as an especially...Two IF Statements with two answers
In cell J9 I need a formula that would do the following:
If G9="Yes" then F9, If G9="No" then -f9
Note: G9 has a drop down list with Yes, No answers.
If there are no other alternatives that yes and no
> In cell J9 I need a formula that would do the following:
> If G9="Yes" then F9, If G9="No" then -f9
> Note: G9 has a drop down list with Yes, No answers.
=IF(G9=&qu...All Replies from One Account Regardless of Which Received
I have two accounts set up in Outlook 2007.
I want to receive mail via one but when I hit reply have OL automatically
use the other. I have already set the other as the default account in
TOOLS-- ACCOUNT SETTINGS. Is this possible and if so how?
No it is not possible automatically. Outlook used the receiving account =
to send by default. You would need to change it manually for each item =
you send (use the Accounts button).
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After furious head scratching, BigK asked:
| I have two acco...Select cheques
When you are building a batch of cheques for one creditor and you add to the
batch several payments the payments print out on seperate remittances even
though you have specified to print one cheque per creditor. You have to go to
edit payments to put all the payments on the one remittance advice.
Can this additional funtionality be added to this screen.
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 message pane. If you do not see the button, ...Two axis
Positioning the Vertical axes:
I have a chart where there are two axes. The first implementation produced
the two scales on the right side, one inside, the other outside the chart
area. Unusual, but luckily it fits well the chart.
I tried to duplicate the feat with another dataset (similar in structure)
and did not even get the second scale to show right, left or center (data
plotted with two different scales allright).
Where is the info to control these functionalities?
On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <firstname.lastname@example.org> wrote=
> Positioning the Vertic...OT: A New Type Of Computer.
A man showed me his computer the other day.
It was made out of wood, about a quarter of an inch in diameter and about 7
It had graphite going up through the middle of it and the delete button was
on the end (made out of rubber).
He said a power outage had no effect on it.
Maybe I need to trade my computer in on a newer model like his.
"Urlay Nook" <UrlayBurlay@TheNook.com> wrote in message
:A man showed me his computer the other day.
: It was made out of wood, about a quarter of a...Importing Office data file into Personal Folder
Using newly upgraded Win XP and Outlook 2002, I am unable to import to my
Personal Folder a file labeled "outlook.pst" but file type Office data file.
I have tried without success, using DB 287837, to convert the Office data
file to an Outlook data file, but the conversion is not reflected in Win
Explorer. Any suggestions?
CTW67 <CTW67@discussions.microsoft.com> typed:
> Using newly upgraded Win XP and Outlook 2002, I am unable to import
> to my Personal Folder a file labeled "outlook.pst&...plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
I can read your question 2 ways;
A) you data looks like this
Select the data and make an XY chart
B) you have two sets of data
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Ser...Import mutual fund prices in to MS Money
Is there a way i can import latest prices of my funds in to MS Money using
QIF or OFX or any other way.
I am in India and i use Money 2004 Delux. I want to update the prices of my
funds. I am a programmer and can write code to import files in to Money if
it can update the price.
But if you want some serious programming joy you could sniff the protocol
they use to get them over the web and do some creative
routing/spoofing--right up until your copy times out its online services and
refuses to even try to get quotes over the web. For M04D, you should already
be past t...Reclassify an Investment from a STock to a Money market intestment
How do I reclassify Reclassify an Investment from a Stock to a Money market
In microsoft.public.money, DB wrote:
>How do I reclassify Reclassify an Investment from a Stock to a Money market
It is not trivial, but not as hard as it first appears. A few
minutes should do it.
In the details, remove the symbol, and rename the existing
investment to something you will never use. Let's suppose you
Create a new investment with the correct type, name and symbol.
Go back to investment zzzz and choose View: Investment Details.
Change each...two variables
I have a query that asks for collcode, collcode2 and booth. On any given day
an employee may be collcode or collcode2. I would like to know how many
times a certain emp has been paired with another employee. So how do I ask
if an employee has been collcode/collcode2 and who the other person was? I
hope this question makes sense.
Thanks for any help
SELECT CollCode, CollCode2, Booth
SELECT CollCode2, CollCode, Booth
SELECT CollCode, CollCode2, Count(CollCode) AS TIMESPAIRED
GROUP BY CollCode, CollCode2