combining 2 columns of data
my problem is i have a list of names (one column of first names, and one
column of last names), my boss says we need to have the first and last names
in the same column. Is there any way that the Data can be combined without
having to retype all 5000 names??
You can write a formula in a new cell to combine cells. For instance
if the first name is in A1 and the last name is in B1, you can write a
formula in C1 like this:
This joins the value of A1 with a space and the value of B1. If you
need to you can arrange it to be last name comma first name:
=B1&a...To Do Bar Task List
This is a multi-part message in MIME format.
If I recall correctly if I had a sub-folder in my task list then items =
in these sub-folders did not appear on the OUTLOOK2003 TaskPad list. =
This was either by default or I had somehow managed to filter them out. =
On OUTLOOK2007, items in tasks sub-folders are included in the To Do Bar =
Task List. I can't figure out a way to filter these items out.
Any ideas? Thanks.=20
Greg Maxey/Wo...Calculating only certain weekdays
I have a spreadsheet that looks similar to this:
Wed 1/1/2003 71
Thu 1/2/2003 204
Fri 1/3/2003 145
Sat 1/4/2003 60
Sun 1/5/2003 40
Mon 1/6/2003 203
Tue 1/7/2003 182
Wed 1/8/2003 228
Thu 1/9/2003 175
Fri 1/10/2003 149
Sat 1/11/2003 112
Sun 1/12/2003 125
Mon 1/13.2003 131
Tue 1/14/2003 139
Wed 1/15/2003 218
I want to get a mean (average) of all of the Wednesdays, then all of the
Thursdays, and so forth. The spreadsheet has over a year's worth of
entries, so I long ago reached the li...PO not listed for Invoicing
We have a Drop-ship PO with status Released and Revision 0. We can view it
under All Purchase Order Transaction window. But when we try to invoice it
from eith View->Purchasing Lists window or POP window, it's not listed under
the Vendor name.
Any help is appreciated.
Any chance already assigned to an Invoice Batch?
> We have a Drop-ship PO with status Released and Revision 0. We can view it
> under All Purchase Order Transaction window. But when we try to invoice it
> from eith View->Purchasing Lists window or POP window, it&...category lists in public folders
Does anyone have a way of easily duplicating category
lists in public folders to all users of the folder.
I have several separate publisher files (publications) that I need to
combine into one publication. They resulted from several catalog merges.
1. My first choice would be to insert them in their proper place in the
2. A second choice would be to concatenate them, adding each on until the
publication is built, though this might take more preparation up front.
Is there a way to do either of these things in Publisher? Failing either of
these, I would try going back to catalog merge and letting it add to the
Create new blank pages where yo...Division on a totaled number
I have a worksheet where I have a column that has number of participants to
attend a class, a column that has the length of class and then a column that
has a formula to multiply the number of participants times the length to get
a total amount of time trained (example 15 people in a one hour class is a
total of 15 hours). The column with the total amount I have auto summed so I
get a total number of hours for a month. I want to know take that total for
the month and divide it so I know how many minutes that breaks down to. I
can not get any formula to come out right for me.
I know ..."Too many different cell formats" error
Receiving this pop up error message when opening a .xls
file. File will not open. Any suggestions on how to fix
and save file?
XL: Error Message: Too Many Different Cell Formats
David McRitchie posted this
Leo Heuser posted a macro 2001-05-06 in programming as a very major revision of the macro in the eee007 article.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
I have defined an CObarray class called CReference, which I've made
I'd like CReference to contain a list type varailble that contains a list of
strings, So I thought I'd use the CStringList class. Thus my CReference
class CReference : public CObject
and my serialise looks like
void CReference::Serialize(CArchive &ar)
ar << notesrefs << notesresources << titl...Advanced Filter Problem with Unique List
Ok, I've used Advanced Filter to created a unique list of City names.
When the list is produced, the first city is always listed twice. The
rest of the cities are unique. Has anyone ever experience this
problem? I'm using Excel 2003. Please help !!!!
this normally happens when the column does not have a "heading" field, ie
City. If you add a heading field into your data does it now work?
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Faulk" <email@example.com> wrote in message
news:111...I need to combine a bubble chart and a line graph (Excel 2003)
I have a simple data set of:
Column A: X axis
Column B: Y axis
Column C: Bubble width
I have the bubble chart complete. Now, I want to plot the X/Y axis data as
a line graph OVER the bubble chart to show the sequence of the data points
from start to finish. Excel HELP is no help.
Is there a way to make a second graph (the line graph), change the
background to "transparent" and then copy it over the bubble graph? Or, is
there a better way to get what I need?
Thanks for any help!
Bernard showed how to make one chart transparent in your other thread. I have a very
simpli...many-to-many relationships by Graham Mandeno
Hi to all,
A couples of months ago I was looking for a good way to handle a many-
I finally found this sample db: http://www.accessmvp.com/KDSnell/SampleDBs.htm.
It's simply great! Unfortunately it doesn't work in my case because
instead of using just numeric ID to relate the table I'm make use of
In the previous:
Graham told me that there was a way to give to the sample db this...When forwarding an email how many recipients can I send it to?
I got an error response when I forwarded an email to many in my address book.
It said, something about too many recipients. How many is too many?
I set a 300 recipient limit to my Exchange users at work. This is set
at my server level.
Quote from http://office.microsoft.com/en-us/outlook/HA012002371033.aspx
Many e-mail service providers set limits for the number of names
that can be in the To, Cc, and Bcc fields in a message. For example,
your e-mail service provider may limit each message to a maximum
of 100 e-mail addresses. If these addresses can be distributed among
the To, Cc, and ...Too many clicks! Available formats box
I have a client who is unhappy with the amount of clicks in Word 2007. One
particular frustration is the Insert Date and Time Available Formats box.
Is there anyway to get Word 2007 to just insert the default Date without the
additional steps of the format box? I know to the average person, it's not a
big deal but this user lives in a pressure cooker and needs the useability of
Word 2007 to make things faster, not slower.
Thanks for your suggestions!
Ask the client to add the Date & Time command to the Quick Access Toolbar
...Should this be one to Many or Many to Many.. Relationship
New to Access learning... I have
Table 1.. Publisher
Table 2.. Books
I was wondering .. Should I create Transient Third Table e.g.
Or Should I put PublisherID key AS Foreign key into Books Table ?
which would be Practical
E.g Books Publishers
Pk BookID Pk PublisherID PK
...Convert list of pairs [a(i),b(i)] to table that shows # of occurrences of each pair
Given something like this:
I'd like to create a table that has three rows (the fruits) and three
columns (the months). At the intersection of each row and column I'd
like the number of occurrences of that particular fruit-month pair.
Thanks for your time.
Assume your data is in the range A1:A14, and you have a
grid starting in cell C1 that looks like:
C D E F
1 jan feb mar
...Restricting Delivery of distribution lists
I want to restrict delivery to my distribution list to just the members of
the list. Can I simply add the distro list to the Accept list, or will I
have to add all of the individual members?
Yes, that is all you need to do.
"Tim Kowal" <firstname.lastname@example.org> wrote in message
>I want to restrict delivery to my distribution list to just the members of
> the list. Can I simply add the distro list to the Accept list, or will I
> have to ...Available Macro List
Is it possible through VBA to get a list of custom macros is the active
Thanks in advance
> Is it possible through VBA to get a list of custom macros is the
> active workbook?
> Thanks in advance
...Using the Common Feed List in Excel
Is it possible to collect items from the Common Feed List (RSS feeds)
generated by IE into Excel? I would like to screen a bunch of feeds from
Craigslist and eBay and none of the readers I've tried seem to do it very
I have used the IE application with Excel to read 1000's of webpages.
Depending on the Website it can be very simple, not so simple, or very
complicated. Not all webpages are the same even though the make look
similar. I don't know what you mean by "to do it very well". The code
may not be simple.
I would have to see the U...Combination Charts #4
I need to create a chart that:
1) tracks number of hours posted by different teams against dates
2) shows different phase of a development cycle against dates
The first element is okay, we've managed to do that. A simple line
graph showing each teams number of hours tracked against a date
The 2nd element - what I want is columns, spanning across the dates,
for the different phases.
griolfc's Profile: http://www.excelforum.com/member.php?action=getinfo&...Too many fields
I have a table and I think it is normalized based on other postings I
There are about 500 object<->value pairs, that needs to be tracked for
500 different objects on every single day of the year. And, all 500
objects should have a value for that day. Object 1-30 is about one
topic, Object 31-60 is about another topic, etc.
tblObjects, I have 500 records like this
(pk) fldObjectID - autonum
fldObjectName - Text 50
(pk) fldDate - Date/Time
(pk) fldObjectID - (fk) to tblObjects
fldObjectValue - integer
Now, I want to show the 500 records of tblObjects ...How to change Series order in a Combination Chart?
I have 3 series of data in my chart:
1st two series are in a Stacked Column chart
3rd series is a Clustered Column Chart
They are in the order as follows:
(Where Series 2 is stacked on top of Series 1)
I want to change the series order now as follows:
I tried right clicking on my chart and went into Format Data Series - Series
Order and change the Series order there. Nothing happens.
Why is this not working? And, how do I change the series?
P.S. I have gone through Jon Peltier's example ...Coutry list
I need a list of Countries in alfabetical order to make a menu where I can
pick up my choise.
Any ideas whre to start looking?
>I need a list of Countries in alfabetical order to make
a menu where I can
>pick up my choise.
>Any ideas whre to start looking?
This will take you to a list of the ISO Country Codes.
These are the codes used to identify the origin of e-mail addresses, so all
countries are listed.
===========================...Using Macros to remove a name from a list
I own a small business with roughly 45 employees (mostly teenagers). There's
lots of turnover. I've got a spreadsheet that I use to track tips according
to the role and shift that our staff works. My manager has the ability to
select the staff member who earned the tip from an in-cell drop down list
(using DV). Here's my question.
I want to make it really easy for my managers to add or delete staff members
from the drop down list. I've created a separate worksheet with two
sections: "add staff member" and "delete staff member". When they want to...Too many many-to-many?
To all, I hope you can shed some light on this for me.
I am using Access 2003.
I have three main tables
3) Service (general contracting, soil testing, architecture, etc)
I have two 'join' tables to create a m:m relationship between Projects and
Contractors and Contractors and Services
I would like to be able to create a form where I can select a project, then
select one or more contractors, then select one or more services that each
contractor could offer (and track when they start and end those services...