Joining/appending two columns of data
I have two columns of data. For example; one with a list of people in the IT
department and the other a list of people in the whole company.
I am after a way of joining these two lists of data into one list and
removing the duplicates; ie only include the people who are in the IT
department once as they will appear on both lists.
I am at a loss how to do this. Any ideas?
as a starting point:
-...Windows Auto Login
I have my Windows Live set to automatically log me in when I invoke the
application. However, on one computer, it always asks for my password. Any
It's asking for my email password (hotmail account). It seems that I have
to enter it once per day. If I get on a 2nd or 3rd time, it doesn't always
ask for my password again, however, it definitely will the next day. I'm
not sure if it has to do with the reboot, but it will ask for my email
password again. Again.. my other computer logs me in each and every time.
Windows Live Mail (not Wi...Deleting XML Record from Dataset removing table?
When I delete the last record from my dataset and then WriteXML() to the
file; the Table itself, in the xml file, is removed. I need to prevent the
table structure from being deleted if there are no more records to be
written to the XML file from the Dataset.
Any ideas here,
"John" <firstname.lastname@example.org> wrote in message news:eEDs6IW4FHA.400@TK2MSFTNGP09.phx.gbl...
> When I delete the last record from my dataset and then WriteXML() to the file; the Table itself, in the xml file, is removed. I
> need to prevent the table structure from being deleted
...Count Unique records in Pivot table
I have spreadsheet full of data and one of the fields, "chassis", has
the chassis repeated down the list more than once.
Is there anyway that when I'm in the pivot table I can count unique
records rather than just count ?
You could add an additional column to your data table. Put a formula like:
And drag down.
The formula for the initial entry will evaluate to 1. The remaining will be
> Hi All,
> I have spreadsheet full of data and one of the fields, "chassis", has
> the c...Excel auto filter does not show all choices for the field?
I have a spreadsheet with client information in approx 3900 rows. Using auto
filter to scroll through alphabetized last name field, the data ends part way
through alphabet. Deleting that row, or a group of rows surrounding that one,
doesn't change the result, it always stops at the same line number. This is a
recent problem, it worked fine for two years!
Jim, AutoFilter dropdown list will only show 1000 entries.
Have a look here for details
Always backup your data before trying something new
Please post any response to...OExp how to auto delete OLD files from deleted folder
Are there additional mail rules that I can load that will
auto delete old deleted messages? I want to delete
anything over 90 days old that is in my deleted items
...Appending Multiple Worksheets
I've been sent 85 single worksheet files (none of which
are very big) and I want to create a master spreadsheet
that contains the contents of all of them - but I don't
want to have to open each spreadsheet and copy and paste
them into the master.
Is there a quick way of inserting the contents of multiple
spreadsheets into one? All of the sheets are in an
"Big Daddy Train" <email@example.com> schrieb im
Newsbeitrag news:412a...pivot Table Group
How can I group all of these into like a Month. So that I can take
everything that happened
in January and sum it up. Each one of these would have a dollar amount
attached and we
keep track of the whole year.
What I want to do is show the total by month. So basically I want to select
January and have
a total or sum of all the accounts that happened during that month. How do
I group all the
days together so that I only have to choose January as the month.
01/01/04 Balance Forward
01/02/04 ADP Fees
VOID ...random numbers
Is there a way to use the'Rand' ,( randomise), function
IE: enter 45 numbers in a column and have them randomised in another column
All the best,
The RAND() function returns random numbers between zero and one. To
randomize a group of numbers that you supply, enter your numbers in on
column, enter =RAND() in another column, and sort both columns by the
Keith Partridge wrote:
> Is there a way to use the'Rand' ,( randomise), function
> in Excel.
> IE: enter 45 numbers in a column and have them randomised in another ...Inbox Showing Incorrect Number of Unread Messages
I'm having an issue with a user's mailbox - Outlook 2003 or 2007, Exchange
2003, Windows XP - that I could use some help with. The Inbox indicates that
there are 47 unread messges, and when I hightlight the Inbox in the
navigation pane the Status Bar at the pottom of the Outlook window says that
there are 47 total items in the Inbox, but when I look at the message list,
there are only 19 messages visible. I've verified that the View settings are
set to show Messages, and I've verified that the exact same situation exists
in the Unread Mail folder. There are no ...How to connect to remote server and access the tables
I am working on Vb.Net application. I have to connect to remote server(it's
IP address)(this server is not on my network). This company has provide me
username, companyname and password. Once, I get connected, I get the
SessionID. Now, I need to download some of the tables from here. How do I do
Pls note, this company has some web services. If I create a reference to
it's web services, how do I access it's database(tables)?
I appreciate your quick response and thanku in advance
If you connect just to a web services then you need to know what they return
to you when y...Appending to an Attribute
This is a multi-part message in MIME format.
Is there a way to append to an attribute in XSLT.
<input name=3D"emailaddress" style=3D"width:200px">
<xsl:attribute name=3D"value"><xsl:value-of =
select=3D"@dvalue"/><...Get number in cell add to it and put back in same cell
I have files that I need to insert or delete x number of lines from. When I
do I need to fix index values in the file that are values in a certain
column. for example
Cell F10 has a 8
F11 has a 9
F12 has a 20
F13 has a 15
If I insert 5 lines between line 11 and 12 I need to add 5 to F12 and F13 etc.
There might be a way to do this but i'm unsure.
in the spreadsheet you could use this formula
This would provide the row number for the first cell.
If you can write macros you can use
activecell = activecell.row
I hope it helps,
"Dave" <...Append Many Word Documents into a Single Word Document
I have 60 word documents in a directory that I would like to append
into a single file. Is there an easy way to do this?
Has anyone written a macro that can append every word document in a
directory into a single word document?
I very much thank you for your help.
Please do not post the same question separately to multiple newsgroups. See
the response to your identical post in the
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - ...summing based on auto filter
I have a spreadsheet with several hundred rows and many
The formula in column "C" sums values for all columns
from "D" through the last column for its respective row,
e.g., column BG.
Column "A" has different criteria that I use to Auto
The result of this auto filter will produce a different
number of rows displayed.
Sometimes 2, sometimes 10, sometimes 50, etc.
The number of rows and columns are added to daily.
Is there a way to sum the values in column "C" based on
the auto filter?
That is, if the auto filter results in 2 rows...Append and Append To priviliges
Anybody know what these two priviliges do for a record??
Append allows a user to be able to add items to an object for example you
can append an address to an account.
Append to allows a user to append this object to something else. You would
need append to priv on the address object.
They work together.
"Jay Mehta" <firstname.lastname@example.org> wrote in message
> Anybody know what these two priviliges do for a record??
So, in the example you gave of appending an Address object to an
Account object,...auto. email notification
Is there a way to set up Outlook Express so that it will
automatically notify me when a new email has arrived,
with icon or something. Right now I have to constantly
check for new messages.
On the menue, click Tools -> Define send/recieve group ->
and then look for schedule for automatic send/recieve.
check that box and you are done !
>Is there a way to set up Outlook Express so that it will
>automatically notify me when a new email has arrived,
>with icon or something. Right now I have to constantly
I create a Pivot table and it work fine. If I update any of the source data,
the table result does not change. Do I have an incorrect Option or is this
just the way Pivot tables work?
You need to right click in the Pivot Table and hit 'Refresh Table', can be
done automatically with code,
"wal50" <email@example.com> wrote in message
>I create a Pivot table and it work fine. If I update any of the source
> the table result does not change. Do I have an incorrect Op...Release free space reserved for tables
I recently migrated a 1.4 TB database from SQL Server 2000
to 2008. More recently I did a DBCC UPDATEUSAGE on tables that
are not written to 24/7 (e.g. appended to during a nightly window but
only read from throughout the day). Now sp_spaceused shows some tables
with a significant amount of unused space. As the tables
grow, the amount of unused space is increasing, not decreasing;
SQL Server does not seem to be using this already reserved space
(or uses it but then reserves more).
1. Is there a best way to "unreserve" the unused space while
maintaining 24/7 access to a ...Append to Append Query
First of all, my apologies to anyone who read this in the Forms Coding group.
I had misposted it there, when it should have been here.
Here is my post:
Awhile back, I posted about the following:
> Have a main form and sub form.
> When generate a new form, fill in the main form and tab to sub-form, an
> append query is executed that populates the questions and possible answers
> for the questionnaire selected in the main form. The user then selects
> Now, however, additional questions have been added. This means I need to
> execu...Pivot Table Not Refreshing Properly?
After creating a PivotTable, I discovered that there were several errors in
the underlying data which caused improper values to show up in the
PivotTable field drop-down lists.
I have since re-generated the underlying data and replaced it in the Excel
workbook. However, upon "refreshing" the PivotTable against the new data, I
find that the 'improper values' still show up in the drop-down lists despite
the fact that they no longer exist in the data!
How can I remove the bad values from the drop-down lists without entirely
rebuilding the PivotTable?
Thank you for any help!
...Re-Post Append to Append Query
Awhile back, I posted about the following:
Have a main form and sub form.
When generate a new form, fill in the main form and tab to sub-form, an
append query is executed that populates the questions and possible answers
for the questionnaire selected in the main form. The user then selects there
Now, however, additional questions have been added. This means I need to
execute some kind of additional append query that will ignore question ids
that have already been populated, and add new ones.
As he so often does, Allen Brown very kindly posted responses and I ha...Autoupdate Pivot Table for New Range
I have a 50-sheet workbook. The first sheet contains a
long list (>40,000 rows) and the next 49 sheets each
contain a pivot table that collects data from the first
Each month the number of rows in the list changes as rows
are added and deleted. Each month I have to update the
pivot tables. How can I do this without having to use the
wizard and manually drag through the new list?
If you use a dynamic formula to name a range, then use that as the
source for the pivot table, the new data will be included when the pivot
table is refreshed.
There are some instructions here:
...Continuing list numbering from one slide to the next in 2007
I have a slideshow with various numbered lists that span more than one slide.
I know that it is possible to hardwire the starting number of a list to a
particular slide. However, depending on the intended audience of the
slideshow, I may wish to remove various points from these lists.
Is there a way (maybe with code?) for the list numbers in subsequent slides
to update automatically, without me manually having to go through and reset
the numbering "Start at" value for each individual slide?
Any help in this matter would be greatly appreciated.
Many thanks ...Pivot Table #20
From Excel 2003, is there a way to format the pivot table result to have the
Data section to span through columns instead of rows?
Let say I chose 2 Data elements per Zip code: No of Patients, No of
What I want to happen is the following;
Zip Code (Criteria): Column A
No of Patients: Column B
No of Doctors: Column C
What is happening right now is that both No of Patients and No of Doctors
are in Column B on top of each other.
Is there a way to do this?
Thank you in advance.
You have an indicator column in your raw data, right?
Drag that to the column fi...