Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <email@example.com> wrote in message
news:08D989CB-D1B4-49F...Sequential ticket numbers and printing 4 to a page
i have mail merged my numbers from excel into my publisher ticket. Thanks
that worked well, now i want to print 4 tickets to an A4 page and in print
preview, i get 4 tickets all with the same number on one page. how do i get
Print preview showing all the same is a bug. Print a test page.
Mary Sauer MSFT MVP
"Neyol" <Neyol@discussions.microsoft.com> wrote in message
news:90034D4C-9951-4550-9DAC...Excel template issues
I have a user that has a excel template on his network home dir
NW 5.1 Server
he says that after he creates a new file from that template - he goes to
open and it tells him read only access
running Excel 2000
...Creating a letter from template
Is it possible in CRM?
So far the only way i figured out to use templated is in an email and
/KB-article. (And order offcourse)
The thing i'm looking for is when selecting a contact, somehow i can make a
letter activity and call a template that puts name & adress data etc. After
that i should be able to print the letter, to put it in an enveloppe and send
So far it seems to me this cannot be done, but then again, i'm certainly not
a CRM expert...
Is it possible?
If so, can anyone provide me the actions to be taken step by step ?
"_Kas_&...CRM 4.0 External Connector
Can anyone point me to CRM 4.0 External Connector installation guide?
"Mandy" <Mandy@discussions.microsoft.com> wrote in message
> Can anyone point me to CRM 4.0 External Connector installation guide?
The external connector is a license so nothing you need to install.
thanks for update. would you know if there's any specs on how it integrates
"Robert MacLean" wrote:
> "Mandy" <Mandy@discussions.microsoft.com&g...reply #4
When I am replying to a massage it does not get mark down
as replied, any ideas?
"mike" <firstname.lastname@example.org> wrote in message
> When I am replying to a massage it does not get mark down
> as replied, any ideas?
That's because you are using the Web interface. If you need to see which
posts you have replied to, then you need to use a News reader. Try OE for
starters, go here to see how to set it up.
...Where do I find SSADM 4+ templates in Visio ?
Hi, I understand SSADM 4+ templates were available in Visio 2002. I have just
moved from Smartdraw to Visio Professional 2003 and am having difficulty
finding SSADM 4+ templates.
Does anyone know where I can find these templates? Are they still available
in the 2002 version?
...Exchange 2003 SP1 to get DST patch & Exchange 2000 patch is available to anyone for $4,000
This is a multi-part message in MIME format.
In the "New Highlights" section: "Exchange Server 2003 SP1 will now be =
supported for an updated version of the Exchange CDO patch to be =
"DST Hotfixes for products in Extended Support can now be purchased for =
...Why does 62 KB translate into 4.2 MB in Publisher?
When I added a 62 KB jpeg to my page, the overall file size jumped from ~275
KB to 4.2 MB. What gives?
Let me guess - Publisher 2000?
MVP Microsoft [Publisher]
"Publisher induced baldness" <Publisher induced
email@example.com> wrote in message
> When I added a 62 KB jpeg to my page, the overall file size jumped from
> KB to 4.2 MB. What gives?
Publisher 2000 doesn't support compression.
PUB2000: File Size Increases Unexpectedly When You Insert Picture
...Visio 2003--Can't drag objects from templates into flow charts.
Utilizing Visio 2003 in an Microsoft XP environment, I have not been able to
drag objects from templates onto flow charts. I do not understand why.
...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...Too many different cell formats #6
I am running into the error message:
Too many different cell formats
Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.
I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.
One idea -
Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.
You can also see the source code for ...format cell #4
In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?
Without invoking something more technical, you can select the cell(s) and go
to Data>Validation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.
> In Access, I can set up a field that "forces" the user to enter in...Add a blank page separator
How do I add a blank page automatically as a separator after every 15 pages
when printing a document of 250 pages?
Use a macro containing the following code to print the document:
Dim i As Long
Dim blank As Document
For i = 1 To 240 Step 15
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:=i, To:=i + 15
Set blank = Documents.Add
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professio...Does anyone have a format or template for a Education Cover Letter
Does anyone have a format or template for a Education Cover Letter?
To Whom It May Concern:
Enclosed please find an education.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"eb" <firstname.lastname@example.org> wrote in message
> Does anyone have a format or template for a Education Cover Letter?
"Suzanne S. Barnhill" <email@example.com> wrote in message
news:O3aNFsq2KHA.5212@TK2MSFTNGP04.phx.g...can I use 11 x 14 paper in office documents?
Is it possible to use a larger sheet of paper when using publisher?
Yes. First select the paper size in the Printer Setup.
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> wrote in message
> Is it possible to use a larger sheet of paper when using publisher?
If your printer can handle it, yes.
MVP Microsoft [Publisher]
How to ask a question
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> w...Winmail takes 4 minutes to load at boot time
Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
logging in after rebooting, it takes 4 minutes to load Win mail. I used the
"event Viewer" to see what was happening. It showed ESENT with ID
102--start Win mail, then the next event is ESENT ID 103 4 minutes
later--terminate Win mail.
Anyone have a clue why it is taking Win mail so long to load? Win mail
works fine after computer loads.
> Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
> logging in after rebooting, it takes 4 minutes ...How do I create custom postcards in Word 2007?
I want to create my own postcards using the right size and type of paper for
This depends entirely on your printer. Can it handle the heavy weight
of card used in postcards, and can it handle the unusual size of a
On Apr 18, 2:54=A0pm, Create Custom Postcards <Create Custom
> I want to create my own postcards using the right size and type of paper =
Perhaps the easiest way to start is to get some Avery (or similar) postcard
stock, which will have two postcards per sheet. Then find the a...Freeze Panes #4
I would like to know if it's possible to freeze panes
without the 'freeze panes lines' appearing on the screen...
MOS Excel Expert (not good enough though!)
You might try this. In this instance you would want to place cursor at c7
ActiveSheet.ScrollArea = "$b6:h14"
'ActiveSheet.ScrollArea = "" 'to reset
"Stewart Walker" <firstname.lastname@example.org> wrote in message
> I would li...IE 6/ActiveX assert in CTLNOWND.CPP line 305
I have a problem with an ActiveX inside a web page.
A random ASSERT in CTLNOWND.CPP line 305 occours during a GetDC first call.
It's seems wnd handle is still NULL (it begin valid immediatly after). If I
retard calling putting a button in html page it work.
CDC* COleControl::GetDC(LPCRECT lprcRect, DWORD dwFlags)
ASSERT((m_hWnd != NULL) || (m_bInPlaceSiteWndless && m_bInPlaceActive));
This problem occours random (more times on faster machines and in release
mode) and just on "init" time on my control.
Probably my control does this operation in ...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...OWA #4
Can't seem to open attachements through outlook web access.
Thanks for the help. I am using Excel XP. I have a list of
items that come from an Oracle Database. They are vehicle
numbers that begin with a 0. (028,034,039,056, etc) I
have an autofilter and want to filter out numbers >= 028
and <= 039. I always get an empty set returned to me. I
assume this is because these are text items rather than
numbers. Is there a way to accomplish this filter with
Hmmm, not really sure if this is what you mean but have
you tried puting a ' infront of the number, it denotes it
as text. (It is under the " key)
>-----Original Messag...X axis location
I created a chart with x-axis at the bottom.
How do I make the chart have the x-axis on top instead?
(Y axis can stay on the left side as it is now).
I think if you click on the Y axis, go to format axis,
and check the "Value (x)axis crosses at maximum value"
at the bottom, you'll be set.
>I created a chart with x-axis at the bottom.
>How do I make the chart have the x-axis on top instead?
>(Y axis can stay on the left side as it is now).
...Opening Outlook #4
How does one change in which folder Outllook 2007 opens?
"Deebee" <email@example.com> wrote in message
> How does one change in which folder Outllook 2007 opens?
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
I am using outlook 2007 window vista. I can open it there is an error saying
Cannot open your default e-mail folder.File access is denied.You do not have