How to convert numbered cells into blank
Hi I would like to know how do i convert a blank cell to a 'completely' blank
cell. The blank cell is generated under the IF logic (under the " "); but
though we see in as a blank cell it is not completely blank. I need it to be
completely blank so I can plot the graph as non continous, rather than
registering as zero. Thanks for your help in advance.
About 2/3 of the way down the page, look for
Gaps in Chart Series; Blanks Chart as Zero
If this information was helpful...Macro to shade row of searched cell
OK I've looked all over for this but couldn't find it anywhere. I wan
to make a macro that searches for a particular value (that would b
contained in a cell but not necessarily the only value in the cell) an
highlight the corresponding row and not just the cell. I have a macr
that searches for a value and highlights the cell containing part o
the entire value but I need the entire row shaded. Here's the cel
On Error Resume Next
Dim sh As Worksheet
Dim rng As Range
x = InputBox("Enter Search Term", "Search")
Application.ScreenUpdating = F...COUNTIF Multiple Conditions
How do I use countif with multiple conditions
Column B has dates
Column C has Various data or Blank
I need to count the number of non blanks in column C if column A is one
of 3 dates
I have tried the array formula below, but am getting the wrong answer
A6, A7 and A8 are the cells witth the dates in
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getin...How do I determine row number of a cell containing a certain number?
I have a spreadsheet in which some of the entries in column A contain
integers starting with 1 and increasing by 1 until a maximum value
(never more than 50). In between, the A cells are blank, even though
their rows contain data in the other columns. The number of rows between
those with entries in column A is variable. For example, entries might
be: A5=1, A9=2, A11=3, A17=4. So there are three blank rows between A5
and A9, one between A9 and A11, and five between A11 and A17.
The problem is to determine the number of the row that has the highest
number in column A. In my spreadsheet,...Linking cell in Excel to Folder in Outlook 2000
I have a contact list in Outlook that I wish to link to from Excel 2000
D:\MSOFFICE\OFFICE\OUTLOOK.EXE /select outlook:173
works perfectly from the RUN command. However, using the Hyperlink command
in cell formatting does not.
My wife runs a parking lot and needs to be able to click on a parking space,
say 201 in Excel and have the clients contact information come up from
Outlook. In this case the folder 173 contains all the information on a block
of contacts 173 to 210. 173 is by default a .xnt file but Excel doesn't by
default appear to be able to deal with one.
Any ideas ? I obvio...Lock and Unlock multiple tabs at once
How can I lock and unlock multiple tabs at once. This workbook contains 100
tabs. I will be nice to lock and unlock all the tabs at once without having
to go thru the tabs individually
ab., you can use a macro like this
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
"ab" <email@example.com> wrote in message
> How can I lock and unlock multiple tabs at once. This workbook contains
> 100 tabs. I will be nice to lock and u...Search multiple IMAP Foulder
I have various IMAP Accounts in WLM.
All mails are downloaded completely.
Is there a way to search all accounts at the same time?
Something external on my desktop ?
Thanks for your help !
...Enable the option multiple remit-to address feature in MGP 9.0
Please enable the option multiple remit-to address feature that is available
in MGP 9.0.
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/default.mspx?mid=665e97a6-6111-46f5-b7dc-a79645d4552...Link cell to axis maximum and mininum
I have a big number of charts that I would like to change the X-axis maximun and minimum values in an easy way. It would be perfect just to asign e.g. the maximum value to a worksheet cell. Is it possible in any other way to change the chart axis max and min value for more than one chart at a time
have a look at the following site for an add-in that will achieve this
> I have a big number of charts that I would like to change the...Show two value ranges on one axis
How do you show two value ranges of the same data on one axis? (the axis
range is separated by a zigzag/heartbeat style line). e.g. instead of showing
0-50, the axis could show 10-25 and 40-45.
Any help appreciated!
Take a look at Jon Peltier's Broken Y axis example.
"NOKIA" <NOKIA@discussions.microsoft.com> wrote in message
> How do you show two value ranges of the same data on one axis? (the axis
> range is separated by a zigzag/heartbeat style l...Having Formatting Remain on "Called" cell using IF function
I'm using an IF function to call some other cells, but I want to have
the various words color coded, eg ("Certified" is green, "Recertify" is
yellow, and "Not Certified" is red). I have the IF function working
correctly, but when it "calls" the cell to have it display the
appropriate word, the color of each word is not brought along with
it...only the text. Is there a way to be able to color code it so that
the appropriate color appears? Thanks!
Zaraf's Profi...Save multiple attachments
I use OL2007 and I often receieve mails with multiple attachements.
Under the Save as option there have been a choice to save attached files
but this option is gone. How do I reinstall it.
it's now under Other Actions.
> I use OL2007 and I often receieve mails with multiple attachements.
> Under the Save as option there have been a choice to save attached files
> but this option is gone. How do I reinstall it.
Can you guide me?
Running OL2007 SP2 under Vista Home Premium SP2.
It appears that when I'm replying to a plain text message, editing functions
(bold, underline, etc) are disabled. Is there a way to enable them?
You'd need to switch to HTML format - plain text is, well, plain text. That
means no formatting.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchan...Send the Document, may differ some place due to cell contents...
I think subject wasn't so good that tell you what i wanted to do...
I have a text that is about an a4 page in Word.
I have an Database of about 150 firms. And two colums; Company name &
Company name Producktivety
And so goes.
And the text is like;
Company name: a
Company productivety: 90
-...Multiple Sites for a Contract issue
We have customer who has a Main Headquarters site, and then a number of
addresses with one or more items of equipment. Each item is serialised and
would be returned for repair if it was faulted. A unit would either be sent
in exchange or loaned until repaired and if exchanged then the exchange unit
would become the sites contract equipment.
At present I can’t see how you can do this, as a contract only seems to
accommodate one address and an invoicing address.
How can you change the Location address against a Contract Line Item once
the Contract has been invoiced and is read only ? Is ...multiple calendar resources
New to project, so advice would be welcome.
Looking at setting up a new system for project management. Requirements as
1 project manager creating / scheduling installation projects.
10 engineers (resources?).
When creating a new project is there a way of automatically checking
engineer calendars to see if they are available from within project (so that
we don't have to manually check calendars), and we will need to publish and /
or update project tasks, as they are created or modified, to the engineers
What setup would we nee...Copy/Paste cells containing only numbers with .50 in it
I have been trying to come up with a formula that will read each cell in a
column and copy & paste only the cells that contain numbers with .50. I can
seem to properly configure the formula to read any whole number as long as it
contains .50 in it. I want these vnumbers pasted into a seperate column.
Thank you very much for your assistance.
If you truly want the numbers copied and pasted you would have to use =
Gord Dibben MS Excel MVP
On Wed, 2 Jun ...Using a cell to determine a value in a database query.
I've run into a problem recently - maybe there's no good answer, then
again perhaps you can help me come to one.
I have a spreadsheet on which There are three entry fields:
I've managed to map start date to [startdate] in a query and end date
to [enddate] - that seems to work fine. The problem I'm running into
now has to do with the store number field.
In the database, store number is a 4 character field, as of now the
numbers of the store are like 01,02,03,04..HQ,RO. When I try to map
store number to [storenum] in the query, I ...OWA rule with multiple words
If I make a rule in OWA with one word (for example "viagra") in subject this
But how do I make a rule that includes several words in the same rule, based
on the subject ? For example "if there exists words viagra, penis or sex in
the subject, then do..."
...Paste Special drops cells from Word and Excell
Our church is using Publisher 2003 to do our bulletin and newsletter. When
we try and use Paste Special to paste the calendar from Word 2003, it drops
the last row of cells bottom of calendar (they do not show up in Publisher).
If we go back to Word 2003, new document, and paste, everything is there.
The same thing happens when we try to Paste Special from Excel 2003. It
drops the last column of the Excel sheet.
Any suggestions on how to fix this? The calendar and Excel sheet are put
together by another individual ( not the secretary) and emailed to the church
The secre...space between lines to be one
Re: Outlook 2003
I use Outlook to process my e-mail. How would I make the space between lines
to be one (1)?
Sometimes the space between lines is two (2), especially between paragraphs.
"Barry Karas" <firstname.lastname@example.org> wrote in message
> Re: Outlook 2003
> I use Outlook to process my e-mail. How would I make the space between
> lines to be one (1)?
> Sometimes the space between lines is two (2), especially between
> Thank you,
>...Are you documenting all your business processes repeatable actions??
Join us for a Free Webinar on: Relevante Solution - The Business
Process Recorder (BPR)
Date: July 13th 2011 (12:30 PM - 1:00 PM)
Business Processes are the repeatable actions that employees execute
daily: contacting customers, ordering supplies, creating invoices.
Processes are the building blocks of a company, but surprisingly most
companies don't write them down. In fact only 7% of companies document
their business processes. Why? Well, documenting process processes
takes a lot of time.
A new Relevante Solution, The Business Process Recorder (BPR), solves
this problem. BPR...How can I open Posted and Open transactions in one single SmartLis
I want to replace the Sales Transaction SmartList with my own because when we
use Extender fields, the Sales Transaction SL becomes way TOO slow.
I am able to create faster SmartLists through SQL Views, however, I can only
have one type of document status opened in one single SmartList: Open (Sales
Transaction Entry window) or Posted (Sales Transaction Inquiry Zoom). The
Sales Transactions SmartList allows to open both types from the same list.
My users liked the faster SmartLists, but they didnt like that they need to
lookup in 2 SmartLists when they don't know if something is open...Help with cell totals
My problem is that I have two rows, one contains the manufacturers
name, and the other the amount that manufacturer supplies. What I need
to do is get the sum of the amount supplies for each manufacturer.
Company 1 8
Company 2 5
Company 2 7
Company 1 2
Company 1 10
Company 2 12
blackie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15223
View this thread: http://www.excelforum.com/showthread.php?thre...how to edit Adobe file
how to edit Adobe file
Most certainly not in Word.
pdf files, I'm assuming that is what you mean by 'Adobe files', are 'fixed'
files. Their layout is frozen so they look the same on any machine and can
not be edited.
If you still want to edit such a pdf file, you will have to convert the file
to something else, edit it, and then save the result back as a pdf. The best
tool to do the conversion of pdf files to Word documents is probably Acrobat
Professional. Unfortunately, that is a rather expensive product to use for a
few simple conversions. There are ...