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
...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...Contact View Email column as link
Can any one help me to mak email column as link (mailto) in the
contact grid view?
When the user clicks the email link, this should open the blank
outlook email with to email address filed.
I tried in this way...
I make the email column as link successfully, but when I change
Contacts View and come back to default "My Contact View" ,
crmGrid.InnerGrid found null that time...
any one have any idea where is the problem...
here is my code.....
------------ adding this script in HomePage.aspx-------------
window.attachEvent( "onload" , OnGridPageLoad )
var crmGrid...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 ...viewing spending tracker in the register
I recall that in MS money 2004 the spending tracker would appear in the
register against each transaction once a category was assigned to it.
Is there any way to do this MS money 2006, or do I always have to click
on budget to view the spending tracker? Thanks!
...Mutual Funds and symbols
I have two of the same mutual funds, one is being used as a Roth IRA and the
other as a general investment. MS Money 2004 will not allow me to enter the
stock symbol when I created the IRA account (the general investment was
created first and its symbol entered). I am getting a pop-up stating that
the symbol is already in use. How do I enter a symbol for the IRA if the
same symbol is being used for the general fund?
Select the symbol from the drop down menu alongside the box where you enter
Microsoft MVP - Money
For UK tips & fixes see
http://s...Sheet tab properties
Hi again. This is my last question. :)
Are there in Excel sheet tab properties so that i can choose font, text
color or something else not just tab colour? And can i have those sheet
tabs in two or more rows? because my workbook has a lot of
sheets(something like 100 sheets) and it's confusing when you have to
find a sheet .
I don't think you can change anything other than tab color. With so
many sheets you could devote sheet1 to being a table of contents with
buttons or hyperlinks or whatever which display sheet information and
a click takes you to that she...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
...Problems with viewing Calendars from different Hotmail/Live accounts on desktop
Several Calendars from different Windows Live IDs which I have tried to
share with my primary account. However, not all the Calendars appear on the
primary calendar of my Primary ID and WLM desktop does not pick them up
either. Is there a limit to the number of Calendars that WLM desktop can
show? If no limit, what am I doing wrong?
...Tabbing between text boxes in Excel 2007
I have a spreadsheet that has multiple text boxes that I need to quickly type
info into and then tab to go to the next text box, this worked just fine in
2003 but since I changed to 2007 it does not allow me to tab between the text
boxes, any solutions? I would be happy to send someone an example of my
worksheet if that helps.
Select shapes with keyboard shortcuts.
...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...Tabs in Excel
I am wondering if there is a way that would allow me to
move down a row in one of my tabs, and when I went to any
of the other tabs, that same row would be displayed.
Almost like a synchronized movement within the tabs.
While holding the shift key, left click the tabs you want
to sync. Then what ever you do to one happens to the
>I am wondering if there is a way that would allow me to
>move down a row in one of my tabs, and when I went to any
>of the other tabs, that same row would be displayed.
>Almo...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...Add "Significant Figures" to Number tab in "Format Cells" of Excel
Using Excel for science classes (the only classes I ever use Excel for) is a
pain because there isn't an easy way to deal with significant figures.
Sometimes setting the number of decimal places helps. Plus, it would be nice
if excel offered a method for dealing with the number "53,000,000" in which
it had 5 sig. figs. Scientific notation would be useful in this circumstance,
but usually I have to deal with, for example, "10" such that it has 2
significant figures. It really is a pain going through all the data fixing
it to deal with such simple matters.
I am...Can I do a global find and replace on the tabs in Excel 2007
I'm trying to create a template in which each tab has a month designation,
and on the worksheet the colums would have the daily date. Is there any
quick way of doing this? I have already created a couple of months, and have
tried to do a global replace the the dates, but get a dialog box stating no
matching info. Help
Whilst I feel that it is always better to keep all data on the same
sheet, with month as a column, then use filters to select any individual
month, I recognise that there are people who want to work as you outline.
To this end I created a macro which...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?
...Currency symbol in calculation from fullpage report
I have the following code in my fullpage report:
<ROW> Transaction.SalesTaxes.Description "|" Transaction.SubTotal "|"
Transaction.SalesTaxes.total "|" Transaction.SubTotal +
When I print the report, I don't get the currency symbol for the value:
Transaction.SubTotal + Transaction.SalesTaxes.Total
I tried to place "(" and "[" but that also doesn't work.
Is it possible to get the currency symbol throught this config of xml?
Thanks in advanced!
Raymond Bak...Returning a value if data is in a large list
I think you use a IF function but I am not sure.
I have two large lists of numbers. The lists are in columns A and C with
columns B and D blank. In B, I want to insert an "X" if the number in column
A next to it is somewhere in column C. I tried =IF(A2=C:C,"X","") and
=IF(A2=C2;C1000,"X","") but they do not work. Is there a way I can do this?
I like the second way. It'll be faster for larger lists ...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...Changing views in a CSplitterWnd
I have a CSplitterWnd in a multiple document. I need to be able to changes
views of type CScrollView in one of the panes in a static splitterbar. Is it
possible to change them without destroying and creating them every time? I
found some examples, but it seems they work only for FormViews.
Why not hide the previous view and (create) show the new one. If I was
doing it I would create the intial one, and when I would need to display a
new one, hide the old view, I would check to see if I have created one of
the new ones yet, if not create the new view, if so simply sho...