comparing columns of text (cross-searching)
I am trying to figure out a quick way to compare two columns of text for
common phrases. The two columns - one of which has over 30k rows - have cells
with company names. I simply need to identify the companies that are listed
in both columns. However, because the same company may be written with slight
textual differences in either column (i.e. "3M" versus "3-M"), I need to
search based on the proximity of characters to each other (i.e. "3" and "M,"
in that order, within a couple of characters of each other). Ideally, I would
also like tally of t...formatting text on chart for specific values
Please help! I have a list of dates on X axis and # of downtime minutes for
those dates on the Y axis. I'd like to show all of the dates that have
downtime=0 as blue text, but I can't figure out how to make only those with a
y value of 0 show up as blue on my chart. Any suggestions? Thanks in
This page may help with the formatting of axis labels.
> Please help! I have a list of dates on X axis and # of downtime minutes for
> those dates on the Y axis. I'd like to show ...VBA solution to paste text into megred cells
I do realize that merged cells are bad news.
I'm stuck with an Excel 2003 worksheet, which contains this dreaded feature.
Users are complaining that on trying to paste text into merged cells gives
"Data on the Clipboard is not the same size and shape as the selected
area. Do you want to paste anyway?"
"Cannot change part of a merged cell."
Interestingly, though if the user hits F2, which places the cursor in the
formula bar, then the paste operation works!
I'm usually reasonably of Ok with VBA; but this ...counting the occurrence of specific text within a date range
In a sheet I have activities completed by specific staff on specific date. I
want to countthe number of times the activity occurs within each month (a
date range i.e. 05/01/10 through 5/31/10). For each instance that the
specific staff memebr completes the activity their name appears adjacent to
the date the activity was completed. The dates are not in chronological
order, thus the need to be able to search and find each date within the date
range and to count how many times the specific staff member's name appears
within that date range.
Use ce...OUTLOOK 2007
I purchased new notebook from Dubai having Vista Home. While uising OUTLOOK
2007, the email messages make and receipts in Plain text receive in Right to
Left Direction. My requirment is default text direction as Left to Right. I
think problem is coming becuase of arabic or Urdu language which is set in
I have tried all option i.e. set language as English, key board as US, email
template as left to right direction but this problem is not solved till
I request Microsoft or member in Discussion group to help me for solving
Tools, options, left to ri...How to customize Outlook 2003, e.g. remove button text in toolbar?
I cannot find where to do that :(
Right click on the toolbar, select Customize, then right click on the
button, select Default style.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Do Quyet Tien
| I cannot find where to do that :(
Thanks, but why is it easy like customize IE toolbars, just select option
"No text labels...how to make all email address in my address book "safe sender"?
How to make all email address in my address book "safe sender"?
That means I wish all the contact email address in my address book are "safe
sender" and I wish to receive their incoming email without block as spam.
ay <firstname.lastname@example.org> wrote:
> How to make all email address in my address book "safe sender"?
> That means I wish all the contact email address in my address book
> are "safe sender" and I wish to receive their incoming email without
> block as spam.
Version of Outlook? For OL 2003...making a decision tree using excel!
hello all, i`ve been trying to make a decision tree using excel, the problem
i encounter is that i wish to put information in to b11 which is related to
information in b3, the information in b3 is ether 0 or err and is based on a
"y" or "n" being entered, does anyone know which formula to use which will
print a true of false statement in b11
If you mean print "True" or "False" or your error
So you can use YES, Yes, yes, Y, y and get True
everything else will show False
Or to treat the error in ...Calculate number of months
I have a field where I am trying to implement a calculation. I want it to
take the date in a cell and subtract it from today's date to show me the
total number of months between those two dates. So right now, it looks like
=(TODAY())-D3 and it returns 167 - the total number of days. How do I make
it show me months?
THANK YOU IN ADVANCE
"TxWebDesigner" <email@example.com> schreef in bericht
> I have a field where I am trying to implement a calculation...How can I prioritize tasks by number in Outlook 2007?
I am trying to create a custom priority for my tasks in Outlook 2007, but I'm
not able to edit the field that was created when I changed the settings to
include a custom priority. I'm trying to put a number into it, so that I can
sort my tasks in a certain category by number, but I'm not able to.
We aren't watching you and your explanation is missing details.
Where in Outlook are you trying to view the Tasks? There are 3 places to see
If in the Task Folder, what View are you in? If in Tasks folder you
probably need to turn on in-line editing.
Judy Gle...I have a problem with getting a total Sum of numbers (URGENT)
I'd really appreciate if someone could help me here.
I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.
I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
numbe...how do i change or remove a signiture that is under outo text hea.
Someone please help i am using outlook 2003 and i am triyng to change a
signiture that is under auto text. to get into it i open a message push
insert then outo text then signiture. I want to change it. I have closed the
untilted message gone to tools then options then mail format then signitures
then remove all the signitures but the signiture under insert and outo text
is still there
See if this helps:
"nearly bald with frustration" <nearly bald with
firstname.lastname@example.org> wrote i...Counting Texts
If cell A1 contains a paragraph of texts and if I want to count just letter
"W"s (Upper or lower case), How can I achieve this?
Example: A1 contains "How now brown cow" the formula should return "4".
Write a macro and use the VBA functions Instr(strName, "w") together with
Split(strName, "w") and count the number of times that it finds "w" or "W"
"Keith" <Keith@discussions.microsoft.com> wrote in message
> If cell A1 co...Emails missing text
We have about 80 users on our Exchange server. We have 2
users that have an issue with reading their email. It
appears that when they open the email the right side of
the email/text is gone. When I shadow their session I can
see the entire email but they cannot. It is as if they
right section of the text of the email was deleted. I'm
sorry I'm not explaining this well. Any feedback is
...Export excel file to semicolon delimited text file
Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.
If you change your regional settings to use the semicolon as your list
separator, you can save as .csv and it should work. But this may affect other
programs, too--since it's a windows setting.
windows start button|settings|control panel|regional and language options|
regional options tab|customize button
near the bottom.
On the other hand, if you don't want to fiddle with...number in system using arrivals and departures
Is there and easy way to figure out the total number of persons in a system if have access to the arrival and departure times. I have tried to use counts with if statements, but I keep getting the number 1. I know this is not correct. Is there any special macros or functions
you may provide some more details about your data. Could you post some
example rows (plain text - no attachments please) and describe your
> Is there and easy way to figure out the total number of persons in a
> system if have access...how would you calculate the number of hits to your website
can some one tell to me the answer of this question
On a website, how would you calculate the number of hits to your
...text size in reading pane
Where is the font selection / text size control for the
Outlook 2003 reading pane (incoming emails)?
I just bought a brand new dell with windows xp and all
and I can't even increase the text size of incoming
emails as I could with older versions of Outlook Express.
I have been trying to figure this out for around 15 hours
now and have come up empty.
What kind of progress is this anyway???? A program
rendered unable to accomplish such a simple practical
thing like that!!
Im very upset. My vision is poor. Unless I get an answer
soon, I am considering a return of this unit to dell...can't see text in any office files anymore
Operating System: Mac OS X 10.6 (Snow Leopard)
on my macbookpro: can't see text in any office files anymore (word, powerpoint, excel). only when using preview function from OSX. <br>
what's wrong??? <br>
do I have to re-install the all suite? any quick fix?
...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <email@example.com> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
...A way to increase a number in a cell by using the + key
Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
Item 1 Item 2 Item 3
2 5 4
I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.
Any assistance would be appreciated.
That would require VBA
How far are you will...Help Creating A Formula To Copy and Paste Text
Hi everyone. Thanks in advance for any help you may have.
I need to create a formula that searches for a specific word in a
column then cut the word and paste it to another column. Of course
this would be simple if it was the only word in the column, but there
is other text that I would like to remain in the orginal column..
You have a reply at your other thread.
> Hi everyone. Thanks in advance for any help you may have.
> I need to create a formula that searches for a specific word in a
> column then cut the word and paste it to ...reference number #2
Where does the information in the "reference number" field in the
transaction table come from? I see tranactions with reference numbers -
the first part of which appears to be the year, month and day - but I
can't figure out the second part. It is nothing that we have
intentionally entered while ringing out the customer. Pls help.
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.p...number changes to date ... how do I change
I am trying to do an "age" range:
Instead I get September 9, 2004
or October 19
I can't figure out how to change it.
Please help! Thank you!
Change the type to Text, and it should keep everything the way you want
it. If you don't specify a type, Excel takes a guess based on what you
Hope that helps.
Message posted from http://www.ExcelForum.com/
...query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.
Try something like:
SELECT DISTINCT [our product]
FROM [which list all deliveries made];
If you can't figure this out, come back with table and field names.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP