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" <firstname.lastname@example.org> wrote in message
news:08D989CB-D1B4-49F...2004 trial, how do I get rid of it?
My trial is over, and I want my Money 2002 back. Does
anyone know how I can do that?
The easiest way is to use control panel->add/remove programs to remove the
2004 trial pieces (there are two programs to uninstall). Then reinstall 2002
and use the backup file created when you first installed Money 2004 - it'll
be named something like My Money.M10. Any transactions entered in the trial
which you want to keep will need to be re-entered into the 2002 version, as
you can't downgrade a file from 2004 to 2002.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.co...a simple math formula
Hi, I'm new to this and have a very simple question.
I have values, simple numbers representing weight in kg, that I wish to
automatically convert to US pounds.
The 'kg' numbers are in fields B5 - to B77 for example. I want the
conversion result (simply multiplying each B cell entry by 2.2) placed in
the ''cell adjacent. Thanks! Dave Horne
In C5 enter
and copy down through C6:C77
"Dave Horne" <email@example.com> wrote in message
news:upOf6pgUJHA.4916@TK2MSFTNGP06.p...Where to get missing msvcp70.dll?
After I uninstalled a bunch of software, when I run an app it says app
failed because msvcp70.dll was not found.
Re-installing that app does not help. I guess I need to restore the missing
msvcp70.dll. What is the official way to get it?
Some sites offer this file for download but I'm not sure the files are
In my system32 folder there is msvcp50.dll, msvcp60.dll, msvcp71.dll, but no
msvcp70.dll. It is not in the recycle bin either :(
"james" <firstname.lastname@example.org> wrote in message
> After I un...Array Formula #7
I have an array formula that works correct up to the 20th row. It quit
running on row 20 or it does not pick up any information after row 20.
Any help out ther
pete5761's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2961
View this thread: http://www.excelforum.com/showthread.php?threadid=49427
Rather impossible to tell...
What's the formula, and what cell(s) is it entered into? What type of
data is in any referenced ranges?
In article <pete5761.205n5a_1134773401.141...get rid of macro option at startup
I created and then deleted a macro in an Excel file.
Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?
Is there a way to get rid of this since I no longer have macros in this
You need to delete the empty module.!
"Brad Rench" <email@example.com> wrote in message
> I created and then deleted a macro in an Excel file.
> Why do I still get the warning box (i.e. the one asking if I want to
> or disable macros) when I o...AOL IMAP account
I have set up AOL email account as IMAP type and keep getting pop up in outlook " your IMAP server wants to alert you the following: Can't read attachment for message 6438.
this pops up for many times and each time the number is different.
new profile same issue.
Office Version:Office 2007
Operating System:Windows Vista / Windows 7 - same issue.
Submitted using http://www.outlookforums.com
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently p...Labels in Formulas requires manual refresh?
I use Labels in Formulas extensively. (Excel 2003 11.5612.5606)
That is, I tick off Options/Calculations/"Accept Labels in Formulas"
and then use whatever text string I've placed at the top of a column
of data to refer to it.
It has many benefits over Named Ranges, dynamic or otherwise for my
purposes, but one ongoing annoyance.
When I add data to the bottom of the column of data, the in-cell
formula using the label for reference does not change when it should.
Select cell, F2 or double click to open it, Enter.
I have a number of such formulae so updating can be ...Scheduling formula question
I know both are the same equation. Which one is by definition ? "Duration =
Work / Units" or "Work = Duration x Units".
I have a three day task with a resource assigned (Max. Units 100%,
Units:100%). All calendars are the default Standard base calendar; Hours per
day is 9 hours. How do we build the equation to calculate 27 hours of work ?
To be technically correct, the Duration Equation formula is written as:
Duration = Work/(Hours Per Day x Units)
You find the Hours Per Day value on the Calendar page of the Options dialog,
accessed by clic...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...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 =
...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Need help on a formula 05-20-10
I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?
Can't do the "and so on" part, bu...How do I import data from lotus123 & maintain formulas/worksheets
I am trying to convert several complex Lotus 123 workbooks with formulas into
Excel 2003. How do I do this and maintain my formulas and the individual
if the lotus file is a wks version or earlier, xl should open it and let you
save it as an xl file.
if the lotus file is a 123 version or higher, you can open the file in lotus
and save it as an xl file.
if you don't have lotus, find someone who does.
> I am trying to convert several complex Lotus 123 workbooks with formulas into
> Excel 2003. How do I do this and maintai...Getting kicked of outlook2003
Every time I print directly after I get kicked offline
Do you mean that Outlook closes?
"jp614" <email@example.com> wrote in message
> Every time I print directly after I get kicked offline
No, It completely boots me off the network. When I loose connection to
Outlook it takes my computer offline--looses connection...
"Vince Averello [MVP-Outlook]" wrote:
> Do you mean that Outlook closes?
> "jp614" <firstname.lastname@example.org> wrote in message
> ...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Delete contents deletes all data and formulas
When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?
You could try this
tap F5 - Special - Constants - OK
and if that selects the data you want to delete then tap the delete key
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> When I hit delete contents all data and formulas are deleted. How can I
> delete data without deleting formulas?
First use Find...Excel Formula Help
I am setting up a basic excel spreadsheet and really have got no experience
with excel. I want to do something real basic like if A2=laptop display $10
or if A2=desktop display $20 how do I do this?
I think that if the list of options is more than a just a few, a =vlookup()
function would work nicely.
It may seem a little complex to start, but once you use it, you'll find tons of
more reasons to use it.
Debra Dalgleish has some nice instructions at:
> I am setting up a basic excel spreadsheet and really have got no...Formula to find last monday (tue, wedn, thu or friday) for a given month
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.
day: wednesday (or corresponding nr)
Who can help?
Thank you for reading and eventually answering my question.Back
Microsoft MVP - Excel
"Michele" <email@example.com> wrote in message
> I need a...get rid of extra spaces between paragraphs worked only once.
Changed style from Word 7 to Word 3, used help online, but still have 2 left
with spaces I cannot get rid of on my last page. Got any help for me?
Only fools and bigots prefer French over Spanish to be taught in public or
In the Styles pane (Ctrl+Alt+Shift+S), right-click the style name and choose
Modify from the context menu. In the Modify Style dialog box, click Format,
Paragraph. Make sure that Line Spacing is what you want, and that Spacing
Before and Spacing After are both set to zero. Click OK. To transfer the
style definition to the attached template, d...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Get firefox- The fastest web browser in the world!
FireFox is a web browser created by Mozilla,it's the fatest web
browser in whole world
download now from site:
> FireFox is a web browser created by Mozilla,it's the fatest web
> browser in whole world
> download now from site:
If you don't mind it's memory leaks. If you re-boot each day it may not
be a problem for you.
...creating nested formulas from drop down box
Hi, I have cell A1 with a drop down box containing 26 available choices. B1
has the dollar amount matching to the choice in A1 using vlookup. E1 totals
several cells including B1 together. I want F1 to look at A1 and either
enter the number from E1 or NA. Here's billing example:
A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 (total of b-d1)
F1 is the column for January
G1 is the column for February
H1 is the column for March, etc
If A1 = Jan, then F1 should be $16
If A1 = Feb, then F1 should be NA or $0
This is the formula that has been working so far:
=IF((G2="...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...