Addition to a working formula
Thu, 18 Mar 2010 20:25:01 -0700
I have this formula and it works fine.
=IF(OR(S140="No",S140="0"),"",G140*X140)
This is placed in cell p159
I now need to add the exact same information as above to the cells
immediately below the cell listed above.
so
Orinal cells involved
G140 = data s140 = yes/no x140= %
I now need ...
|
Lookup 2nd & last match with two conditions
Thu, 18 Mar 2010 19:40:01 -0700
Hello,
I've a table below, I would like to setup a query which could return a value
showing the 2nd match and last match in the next column. Thank in advance
for anyone great help.
cheers
Billy
Column B C D
1st 2nd
Row criteria criteria Value
3 A Y 1
4 B Y 2
5 C Y 3
6 A ...
|
What caused my paste function not to work?
Thu, 18 Mar 2010 19:05:02 -0700
Even I checked the box under tools/edit/show paste button, I can not copy and
paste from one excel workbook or file to another.
How can I make the paste function work again? When I am in a work book, or
click on Edit, the "paste" option is not highlighted on the toolbar.
...
|
Messy Formula needs clean up help!
Thu, 18 Mar 2010 17:51:01 -0700
The Formula below works, but feels quite sloppy, and I'm sure it can be
accomplished in a much cleaner fashion. In addition, I attempted to add 1
more condition, but realized that I cannot add yet an 8th condition without
receiving an error message (I believe the limit is 7). Any suggestions to
clean the for ...
|
insert rows--->protected sheet
Thu, 18 Mar 2010 17:45:01 -0700
I have a protected sheet in Excel 2007, and I would like to write a macro
that allows a user to insert a new row(s) that also copies the formulas (but
not the text/data) from the previous row.
When I searched for a possible solution, I found the following macro #2,
which works perfectly, if the sheet is unp ...
|
Countif Function??
Thu, 18 Mar 2010 14:57:03 -0700
I would like a formula which will allow me to calculate the number of mondays
in a month which are either C- closed, H- holiday. or TT- term from the
following list. This will be duplcated for each month. I have tried to use:
=COUNTIF(B$2:B$32,"Monday")+COUNTIF(C$2:C$32,"H") but this adds the day and
the let ...
|
loan amortization template
Thu, 18 Mar 2010 14:44:01 -0700
I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?
Thanks
--
Sue W. ...
|
|
|
Use CountIf for a literal string
Thu, 18 Mar 2010 14:25:01 -0700
I am trying to count the number of cells in a range that contain the string
<0.1. I don't want the number of cells that contain numbers less than 0.1, I
want the actual string. Is there an escape character for comparison operators
like the tilde for wild cards?
Thanks,
Chad ...
|
Hlookup with Merged cell as look up value
Thu, 18 Mar 2010 13:59:01 -0700
Hopefully someone can help me out on this one. I have a spreadsheet that
looks similar to this:
2/15/2010 3/15/2010 . . .
Site# INV VALUE INV VALUE
1 34 332 40 440
2 47 250 47 250
3 ...
|
T.Valko function
Thu, 18 Mar 2010 13:10:10 -0700
Morning.
Back in January I'd posted looking for some help on a function, and T.Valko
helped, solving my issue.
In using the function, I've run across something I was not expecting, and
need to now solve that.
The original post was:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&query= ...
|
