[mso] Re: Excel
- From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 12 Sep 2005 13:49:35 -0500
Jenny,
You can use the vlookup function to transfer the phone numbers from one
database to another. =20
Go here to Linda Johnson's excellent article on using vlookup.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=3D446
As for deleting the records, I'm guessing it could be done using VBA,
however that is beyond my vba capabilities. Perhaps someone else could
help.
But as an alternative, I think you could use the exact function as an
array to identify the matching records and non matching records, then
sort on that column and manually delete all the matching records.
The syntax for using EXACT as an array function to compare to a range of
cells is as follows. (Note, an array formula is activated by pressing
CTRL-SHIFT-ENTER rather than just ENTER)
=3Dor(exact(Cell Ref, Compare Range)) then press CTRL-SHIFT-ENTER
The resulting formula will appear as:
{=3Dor(exact(Cell Ref, Compare Range))}. The curly brackets indicate =
that
it is an array formula and are activated by pressing CTRL-SHIFT-ENTER.
If the formula returns an error (#NAME), look at the formula in the
formula bar of Excel and make sure the curly brackets are showing. If
they are not, you did not press CTRL-SHIFT-ENTER to enter the formula.
Place your cursor in the cell, Press F2 to edit the cell and press
CTRL-SHIFT-ENTER to activate the array.
Hope this helps.
Christine McDonald, CPA
Technical Specialist
Information Technology Division (RSA-4)
Western Regional Office
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Jenny
Sent: Sunday, September 11, 2005 12:52 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel=20
I have two databases. One has a column for phone numbers but NO phone
numbers.
The second one has the same info as the first database but it has phone
numbers.
I need the phone numbers from the second db to go into the column for
phone numbers in the first database. =20
If I have to combine these two files to do this ----- then I would like
the records from the second file - the records that moved phone numbers
from it to the first database --- I would like those records to be
deleted. It is possible that there would be some records left (if the
number of records from the first database records don't match the number
or records in the second database.
Thanks a lot. I know very little about this, so I would need to know in
very easy steps.
Jenny
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
