One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...Outlook email account, can't delete
I have Outlook 2002 hitting an Exchange 5.5 server on a
laptop that I've given to a new user. The old user's
mailbox remains in Outlook even though it doesn't exist
in E-Mail Accounts\Exchange Server Settings under the
Tools menu. Nor does it exist under the new user's
account as an additional mailbox. How do I remove it?
Additional info: my Exchange server died last week and I
rebuilt Exchange on a differently named server. The
mailbox that I want to remove attempts to connect to the
old Exchange server. Also, I just upgraded the laptop
from Win98 to XP Pro and ...ad distribution group with non ad mail accounts
I need to set up an AD distribution group with members that are not in AD.
Is this possible?
yes...create the mail-enabled contacts first, then add them to the DL...
Susan Conkey [MVP]
"Brandon Baker" <email@example.com> wrote in message
> I need to set up an AD distribution group with members that are not in AD.
> Is this possible?
...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <firstname.lastname@example.org> wrote in message
news:email@example.com...Workflow for Customer or Account in Service Activity (Partylist)
My Business Goal is to create a workflow that looks at the Service Type and
other values in the Service Activity and calculate billing into a custom
entity. This all seems quite straightforward except for my ability to get
the Account or Contact that is in the Customer field of the Activity. This
is a lookup field of entity type
How would you grab the information in this field? I am using Workflow,
passing the objectID of the activity into the .dll. From this I am able to
grab just about everything I need for my calculations. Howerver, I cannot
seem to get the Account...No outside mail to new accounts
I have an exch 5.5 , we are moving off of, to an exch 2k3 server. All
mailboxes were moved last sept. working fine. Now when we create a new
account they cannot recieve mail from the outside. Any Ideas?
Check the queues... and tell us what you see. Something in event
Buenos Aires, Argentina
On Fri, 21 Jan 2005 08:27:02 -0800, "Benningtonr"
>I have an exch 5.5 , we are moving off of, to an exch 2k3 server. All
>mailboxes were moved last sept. worki...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...Quit creating duplicate desktop icons when doing upgrades/hotfix
Upon any sort of upgrade or hotfix, RMS creates a whole new set of desktop
icons. What a pain! Pls fix. Ask if we want to create new desktop icons,
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, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/...Issues sending to Hotmail Accounts
Good Morning All:
I have a new install of Exchange Server 2003 Standard in a Windows 2003 AD.
I am having issuses with Hotmail. I can recieve from hotmail with no
problems. I can send emailes to every other domain it seems like other than
hotmail. When I go to the Outbound Queue the messages are not there, they
seem to go out with out a problem, however they never seem to get to my or
any other hotmail account. I can connect to mail.hotmail.com port 25 and do
a tracert to there server and have no issues. It is frustration because I
don't get a delay notification or anything....How do I duplicate numbering on a raffle?
I am creating an event ticket but would like to number the tickets on both
the left and right sides of the ticket.
Create a data base with your numbers. Use mail merge for the tickets. You can
insert a mail merge field on both sides of your ticket.
When you merge have one ticket on your screen. What version Publisher are you
using. Some early versions of Publisher shows all the merge items the same in
print preview. This is a Publisher bug.
Mail, e-mail, and catalog merge
"Candi...How to delete "non-identical" duplicate records in an Access table
How to delete "non-identical" duplicate records in an Access Table? Where
"non-identical" duplicate record means a record in the table that has
slightly different datum in one of the fields, but an identical duplicate
datum in the field that I am concerned with. For example:
SSN MRN CLIENT NAME
001-00-2222 11170419 Smith, Jane
001-00-2222 11170419 Smith, Jane T
001-00-2222 11170419 Smith, Jane Thompson
The data of these two records in the fields SSN and MRN are identical; but
"non-identical" in the CLIENT NAME field (notice...How do I get brackets in format cells accounting?
In Excel 2000, "format cells accounting" got me brackets around negative
numbers. Excel 2003 gives me a negative sign. Is there any to change this?
I know I can get the format I want in custom, but this seems to require
formatting each cell.
Highlight all the desired cells. Right click and select Format Cells. From
the Number tab you can select the desired view.
> In Excel 2000, "format cells accounting" got me brackets around negative
> numbers. Excel 2003 gives me a negative sign. Is there any to change this?
> I know I c...Duplicate ItemLookupcode
Any clues on how I could get duplicate itemlookupcodes?? I found a few of
them recently. No SQL queries have been run to generate them and if I try to
create a duplicate itemLookupCodes I am stopped with a message telling me to
use a unique name. How could they have gotten in the database? Any clues,
boos or comments appreciated.
Thanks for all the help!
This is a multi-part message in MIME format.
As you mentioned, RMS Manager doesn't ...Duplicates!
Why do the songs in my media player library often duplicate or tripulicate
themselves, so i end up with a library three times the size it should be. I
have on occassions gone through and deleted all the replicated songs, but
over a period of time they seem to "grow again" filling my library again with
unwanted duplicates, taking up more space and memory. Is there anyway i can
stop this happening?????
What version of WMP/Windows?
First, make sure that WMP isn't monitoring the same folder twice.
Duplicate songs can appear when, for example, both C:\Music a...Find duplicates in a column
I have 6000 emails addresses in a col and wish to know if there are any
How can I do this please.
I have Excel 2002.
Assuming your emails are in A1 to A6000, in B1 enter
copy down B1 all the way to B6000
Apply a conditional format of red pattern on cells B1 to B6000 where Cell is
greater than 1 and all duplicates will be shown in red.
> I have 6000 emails addresses in a col and wish to know if there are any
> How can I do this please.
> I have Excel 2002.
I have Money 2006. I also have a PDA in which Money 2006 for Pocket Pc 2003
was loaded. When I see the accounts to be synchronised, I see only Credit
card accounts, checking accounts, savings accounts and line of credit
accounts. I cannot see the Asset accounts like Home or Loan Accounts like
Home Mortgage Accounts in the list of accounts to be synchronised in active
By the way In transaction register I cannot see special categories like
Transfers, Credit Card Payments, Loan Payments.
I cannot edit or change the previous transaction, but I can only enter new
M...How to setup an account
I recently wanted to try Microsoft Outlook 2003 on my computer, because I
have heard it is easier to check mails with Outlook. So I tried to create a
new account, and I am doing SOMETHING wrong but I don't know what it is. I
want to be able to check my yahoo mail and I don't know if that goes under
POP3 or the other three categories. Also, I tested the account and Outlook
mananged to establihs a network connection, find outgoing/incoming server,
but could NOT log in. It made no sense to me. I did this using the POP3
category. I set up the Incoming mail server (PO...duplicate emails received
I've been receiving duplicate emails. This doesn't happen with all the
emails I receive, only with some of them. "Leave a copy on the server" is
not checked. I don't know the reason why this happens. Can somebody help me.
Thanks in advance.
...Backup and restore for Outlook Contacts
Is there any way I can backup and later restore my
Outlook Contacts? I can export them, but it exports them
to a MS Excel file, and then importing them loses all the
group lists, and other information as well.
>Is there any way I can backup and later restore my
>Outlook Contacts? I can export them, but it exports
>to a MS Excel file, and then importing them loses all
>group lists, and other information as well.
>Click File/Import & Export/ in the box that appears,
highlight "export to a file" then click nex...Delete duplicate record
I have a table with 10,000 rows and 10 columns.
Column 1 has text values, I want to delete the record if they have a
duplicate, that is delete all the records.
So if Column 1 has a two, three, four,... rows with the same value I would
ALL the two, three, four... rows.
I have a query that finds the duplicate, but how do you delete this?
Thanks for your help on this
You could create an exact same table structure without any records. In that
new table make the column 1 the primary key. Then append the table.
> I have a t...Looking for Followup response re: linking Contact Info. into Accounts
I recevied a response from someone named Dodd on Wed. April 28th in the
evening. The email stated that they would post a response with a possible
'work around' solution on Thurs. April 28th. I am still waiting for that
Thank you in advance.
...Outlook 98 Contacts and PAB
As I haven't used O98 for YEARS(!) can someone tell me how to convert,
import or otherwise use the data in the PAB in Contacts view instead of the
File | Import and Export should do it.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Gordon" <firstname.lastname@example.org> wrote in message =
news:%23f1p3fkhGHA.2...RM00401 duplicated document numbers
We are using version 10.00
There are some batches that don't post correctly. When the posting
process begins, is getting stuck in some point in the progress and
When we search in the tables, the documents appear in both WORK and
HIST SOPs. This case has ocurred before, so, what we do is search and
be sure that the GL accounts are ok, affecting the right amounts and
then, delete the transaction of the WORK table.
The problem we have now, is that every time the batch is trying to
post, creates a docnumbr in the RM00401 with the same number and 0's
added. For exam...