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...CRM v4
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
...CRM Objects in MS Word Templates
I got a problem with the Merge function of SFO. When I want to write a quote
in Word so a use the option in the menue. I select a template from word and
then I am asked which Objects I want to include in the document.
I want some information from the products, a custom field I integrated.
Problem is, I cannot slect it in the document, so I digged a little bit in my
I am able to select some information from Products, attached to a quote. For
example the name or the productID are neither in the quote object nor the
quote-detail object, only in the product object. So, obv...Word 2003 Custom Paper Size Won't Hold
In Word 2003 when I set a custom paper size to 7 x 10 inches it won't "hold."
If I go to the margin tab and return, the paper size has switched to B5(JIS)
which is 7.17 x 10.12 inches. Any ideas?
Whenever you choose a size that is that close to one of the built-in sizes
(which are determined by your printer driver), you'll see that result. About
all you can do is throw in the towel and make up the difference with margin
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
my word count says 1 no matter how many words I type
Does this happen with a particular document, only, or with any document that
you open in Word?
Microsoft Word MVP
> my word count says 1 no matter how many words I type
> Please help
...Can I save e-mail from Outlook with attachments as a word doc.
I would like to back up my e-mail with attachments
(either single e-mails or several thousand) to a simple
word document with attachment for archival. Can this be
done. I do not want to backup and restore as I don't any
longer need most of the information.
...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" <firstname.lastname@example.org> wrote in message
> I have a column which contains part of an address eg.
> "Honeyhouse, High Street,"
> Is it possible to r...Can not see all of a pasted paragraph from Word in a cell.
I am making a log book. I paste paragraphs from word into a single cell that
has been formated to be justified and top centered vertically. The cell has
also been formated with text wrap. I can read some of the paragraph and the
bottom half is hidden from me. I have changed the row height and cell
height. The only way to read the last part of the cell is to click on it.
It will not print the whole paragrahp either. Help
A cell can only display 1024 characters. You may extend this with manually
entering line breaks with aLT+ENTER.
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 ...OneNote stops me printing Works Document
I'm new to Vista. Yes, I know, Windows 7 is now available, but there you go,
I'm always last with everything new.
Just bought new Dell 1555 Laptop with 30day Trial MSOffice 2007 (now expired
and deleted). Up to now I haven't been trying to print. Now, every time I
try to print from Works W/P MSOneNote opens and stops me. It shows the
document I want to print, and demands I enter registration code. Can't seem
to get rid of it, and can't figure out how to avoid it, or how to close it
and then print afterwards. If it's part of the Office 30 day Trial should...Word, Form Fields, and the Enter Key
I've posted once on this subject, with no reply. I thought I'd try
again in a different format.
I'm using the code below to act like the Tab Key to go between Form
The problem is that when using the Enter Key, the Form Fields are not
Formatted, as they are with the Tab Key.
Please, someone copy this code into a blank worksheet and try it
yourself, format some Form Fields, and tell me why the code is not
formatting the Form Fields. By the way, after using the Enter Key, if
I go back to the previous Form Field by using the left arrow or mouse,
for example and...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 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
...inserting a word document
I have created a excel workbook with about 6 pages, I need
to include a letter I created in Word as one of the
worksheets in the project. I tried to take the word letter
and insert it as an object into my excel worksheet...this
did not totaly work as I now have a line like a border
around this letter. If any one can please help me, just
email me at email@example.com and put excel in the
I would so appreciate any help I can get on this matter.
Have you tried creating a text box that covers the whole sheet, then inserting
the Word document int...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...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...Problem opening excel documents
We have a standalone workstation with Excel on it.
When a user double clicks on a spreadsheet to open it, Excel opens up, but
then the spreadsheet will not open. The message that comes up is something
to the effect of "path cannot be found".
If the user open Excel first and then using Excel's File-Open dialog box,
the file can be opened.
Anyone have any idea how to fix this issue.
Thanks in advance.
<Tools> <Options> <General> tab,
"Ignore Other Applications".
-----------------------------------...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?
..."Document Not Saved" error today
Just an FYI. I don't know where else to post this, but hopefully it helps
A microsoft update was automatically installed on most of our computers
overnight or this morning. After that we were unable to save to a network
shared drive (mapped drive) in any Office 2007 program. It turned out that we
were only unable to save to our file server which is still running NT4. I was
able to save to a Win 2k3 server ok. I was also able to save to the NT4
shares with every other program I tried.
After removing Security Update for Windows XP KB980232 everything worked
...openning a word file in excel
I'm try to open a simple word document in excel. when I
click on the .doc filename I get the message:
file format is not valid
can someone please help?
You could open the .doc in word and copy|paste into excel.
You could insert a word document (insert|object) into the workbook.
But you can't open it directly (for importing??) in excel.
> I'm try to open a simple word document in excel. when I
> click on the .doc filename I get the message:
> file format is not valid
> can someone please help?
In E...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...How do I paste my Word document with footnotes into Publisher?
I am using both Word 2003 and Publisher 2003. None of my superscripts move
over, though my citations do, but without superscripts. Please tell me that
I do not have to do this manually, I have over 100 footnotes! Is there a way
to import/paste/insert my document into Publisher without sacrificing my
Publisher cannot handle footnotes or endnotes!
"Thesis catalog due soon" <Thesis catalog due
email@example.com> wrote in message
>I am using both Word 2003 and Publisher 2003. No...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 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...