I have a marketing list that contains more than one person from a company
(for some companies). I want to be able to remove the duplicates based on
title. Example: I want to be able to filter the list so if there is a CIO,
CFO and CEO I want the CIO and remove the CFO and CEO. If no CIO then keep
the CFO and remove the CEO. If no CIO or CFO then keep the CEO. The key is I
want the list to have one person per company but not exclude any companies.
I am pulling the list from Leads. Does anyone know if this is possible in
How can you remove filter records which are the same in 3 to 4 columns only
the ones that have in all 3 columns same wording
> How can you remove filter records which are the same in 3 to 4 columns only
> the ones that have in all 3 columns same wording
Assume the 3 cols are cols C to E
In F2, copied down: =SUMPRODUCT(--MATCH(C2:E2,C2:E2,0))=3
Then apply n autofilter for TRUE in F1, delete these filtered rows
please explain more detailed
also if we don't want todelete only copy the filte...Creating an a report from an indivual record in a table
Hi all, I've been searching for an answer to my question for a while and have
got more and more confused as to the best way to approach it...I am a total
novice I'm afraid...
I have an Access 2003 database set up with one table with a unique ID for
each person and numerous other fields. I have set up forms to collect data
(about 6 in all).
What I would like to do is to be able select a unque ID and pull almost all
the fields in the table associated with it into a report. I would do this
for each person when required.
I presume I would have to set up a query first but h...Remove commas at end of line only
I have a column which contains part of an address eg.
"Honeyhouse, High Street,"
Is it possible to remove the comma at the end of the line but not the other comma?
for each c in selection
"Mark" <email@example.com> wrote in message
> I have a column which contains part of an address eg.
> "Honeyhouse, High Street,"
> Is it possible to r...Size of Pivot Table and Chart
I have a spreadsheet that starts at 327 KB. When I add
just two pivot tables (and their associated charts) onto
a new worksheet, the file size increases to a whopping
12.2MB!!!! Is this normal? Is there a way to reduce the
I am sure I have seen this question before on this newsgroup but can not
seem to find the thread.
Is it possible to remove hyperlinks in bulk from a worksheet or must they be
done one at a time?
Delete extra @ to reply
You can copy a blank cell and then Paste Special | Add to your selected cells.
However, this does add a zero to formulas...
= A1 + B1 becomes... = A1 + B1 + 0
San Francisco, USA
"john.bedford3" <john.bedford3@@ntlworld.com> wrote in message
> I am sure I have seen this ...Remove existing property sets doesn't remove
I have created a new custom property sets in Visio 2003 Professional and it
will not allow me the remove the existing property set and replace it with my
...Dotted line to remove
I have just been editing a multi-page word document and something I did has
made a dotted line appear. It goes across the page from margin to margin.
Whatever I do to try to remove it doesn't seem to work. The line was not in
the original so some I assume some key or setting I have touched has done it.
The Word I am using is MS Office Word 2007 - something I find is a lot more
fiddly than the older version I have used for years.
Any help would be appreciated.
<>>< ><&l...remove column in all email views
I put some add in to my Outlook 2003 about 8 months ago that was
supposed to help me keep track of my emails. I did not like it and
uninstalled it. However, any time I create a new mail folder now
outlook automatically makes a thread and categories column. How can I
get it to stop this behavior?
I would also like a way to remove all the categories and thread columns
in all my folders so I don't have to go into each folder and do it by
hand. I am a programmer so doing it programmatically is not an issue.
...Removing "Maximize" from system menu.
I have a dialog based application. I want to completely remove the Maximize
and the Size entries from the system menu. They are grayed now, but I want
them totally removed. I just want a cleaner look since these will never be
How do I do this?
You could try making the main dialog have a Tool Window style set. It will
be smaller, but it looks nice.
"Paco" <firstname.lastname@example.org> wrote in message
>I have a dialog based application. I want to completely remove the Maximize
>and the Size entries f...Table ALIAS of INNER JOINs ?!?!
i'm struggeling really hard on this one! basically i just want to get
the groupwise maximum (in this case the latest entries /
ranks.checked_at). i try something like this:
SELECT urls.url, keywords.keyword, ranks.rank
FROM (urls INNER JOIN keywords ON urls.ID = keywords.url_id) INNER
JOIN ranks ON keywords.ID = ranks.keyword_id AS xxx,
(SELECT keywords.keyword, MAX(ranks.checked_at) AS latest FROM
keywords INNER JOIN ranks ON keywords.ID = ranks.keyword_id GROUP BY
keywords.keyword) AS yyy
WHERE yyy.keyword = xxx.keyword
AND xxx.created_at = yyy.latest;
but ...Borders with Pivot Tables
Is there anyway I can prevent pivot tables entering borders around cells?
Any help most appreciated
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
You may have to enable selection (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)
On the PivotTable toolbar, choose PivotTable>Select>Entire table
On the Formatting toolbar, click the arrow at the right of
the bor...ADC removal problem
I want to go to native mode now that our Exchange 5.5
server is shut down but I cannot because I get an error
saying all connection agreements need to be removed.
I was able to remove 2/3 connection agreements, but now i
can't remove the 3rd. Config CA_SITE_SERVER
The 5.5 server has already been removed from the 2003
Check out the following article, specifically step 12:
272314 XADM: Preparing a Mixed Mode Organization for Conversion to Native
You need to remove the SRS, which will automatically take care o...Table-auto fit to contents?
HI, I see no auto fit to contents command in the table menu in Publisher '02.
Is there a way to do this?
On Sat, 22 Apr 2006 18:34:01 +0100, Catt wrote
(in article <D0C21016-ABAC-49A3-AAFC-BB3054161DAE@microsoft.com>):
> HI, I see no auto fit to contents command in the table menu in Publisher '02.
> Is there a way to do this?
...Removing/changing online Payees
I would like to change/delete/combine some of my online
payees. I know that you cannot combine online payees. Is
it possible to change an account so that it is no longer
an online account, then combine or change all the online
payees that I'm interested in, and then finally make the
accounts online accounts again?
...Removing a keystroke
Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!
Select the cells to want to fix and then use Find/Replace
Gary''s Student - gsnu200909
> Is there a way to remove all spaces within a column of cells? Extra spaces
> are screwing up my subtotals. Thanks!
Select the column
what: (space character)
with: (leave blank--not even a space character)
Did you get this data from a web site?
If yes, then you could be seeing those...Will restoring CRM 3.0 databases to remove bad data cause offline client issues?
We recently did an import into our CRM 3.0 install, and would like to
restore our CRM Db's to remove that data. If we have Outlook clients that
are currently online, but have gone offline and back online agains since the
bad data was imported, what will the effect on them be? Will the data that
is removed from restoring the databases still be on the laptops? Or will the
next time they go offline will it be removed?
...Removing older versions of MS Money
I notice that I have MSMoney 2000 and 2003 in my Add/Remove Programs.
I am getting ready to upgrade to 2007 because Money says it won't
update my investments any longer. Can I safely remove the MS Money
2000 (I assume it is there because I must have decided to install 2003
in a separate location and then import my money file, rather than
simply update MS Money 2000) ? I don't want to do anything to mess up
my money file.
Also - anything I should be mindful of when upgrading MSMoney 2003 to
the 2007 version? Surprises I might not like,etc?
You shouldn't have a pro...Tables to PDF
I'm working with a table in Publisher at the moment & have formatted all my
column / row gridlines to 0.25pt. However, when I convert to Adobe PDF, some
of the lines appear much thicker than the others.
Have you tried printing the .pdf file? I've seen lines that look thicker but
print just fine.
MVP Microsoft [Publisher]
"ianp" <email@example.com> wrote in message
> Hi there,
> I'm working with a table in Publisher at...Removing Exchange 5.5 #2
I'm doing a migration exercise in a test lab without internet connection.
Here's what I have (1 site, 1 domain):
- Win2003 ADC (as a result of in place upgrade from NT4)
- WinNT4 BDC with Exch5.5 SP4
- Win2003 member server with Exch 2003, ADC (connection agreements for
mailboxes, public folder and configuration already defined and seems to work
Exch2003 was installed in Exch5.5 site (I tell it to join Exch5.5 site).
I have just successfully moved all user mailboxes from 5.5 to 2003. We don't
use public folders, so I suppose there is no reason to run PFMigrate tool
since t...PA Remove cost trx should only remove recognized costs
Utility to remove cost transactions in Project Accounting should only remove
those costs that have already been recognized on the project.
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/dgbrowser/en-us/de...store multiple timestamps in one row on table
I am trying to create a form that allows an employee to select their
name and click a command button to store the time they leave for lunch
and another button the time that they return. I have each button
coded to be written to a table, but I would like to have the in and
out times be stored on the same row so I can have a function subtract
the two. Currently, it writes a new row for each click of the
button. Any help would be appreciated.
On Fri, 8 Feb 2008 12:19:56 -0800 (PST), firstname.lastname@example.org wrote:
>I am trying to create a form that allows an employee to ...OE removed accessto "unsafe" attachments
Outlook Express 6 has removed access to unsafe email
I have been receiving this type of attachment regularly
for the last ten years. It is not unsafe.
How can I disable this horrible feature. I need those
Click tools, options, security, and uncheck the 4th line down... "do not
"Beever" <email@example.com> wrote in message
> Outlook Express 6 has removed access to unsafe email
> I have been receiving this type of attachment ...Automatting hyperlink removal
Is there a way to automate the removal of hyperlinks in
excel to specific columns instead of the whole sheet. I
have a user that would like to create macro that would
remove hyperlinks in some columns that she could specify.
You could do it by copying an unused cell, select your column, and go to
"Judy" <firstname.lastname@example.org> wrote in message
> Is there a way to automate the removal of hyperlinks in
> excel to specific columns instead of the whole sheet. I
> have a user that woul...Relation between tables
In the table of the students [tblStudents] of our school containing the
fields of the identification of the students, we had fields concerning the
To reduce the table of the students, we decided to create a new table
[tblDiplomas] with the fields which existed in the table of the students.
However probably for a problem of relations between the old one and the new
table, by adding a new student in the table of the students, we realized
that it did not have his equivalent in the table of the diplomas:
tblStudents = 663 students, tblDiplomas = 662.
tblStudents with th...