|
|
Need help with formula by
Kathryn J Bittman
I need actual two different formulas
1) The first is to count dates in months for start to current, but to stop
counting if an end date is listed. - i.e.
c2 =...
( 1 2)
|
|
13 |
132 |
|
|
Conditional Formating by
carl
My data looks like this:
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
Is it possible to use the conditional formating to do the following:
If value in ColA...
|
April 3rd, 2006 07:39 PM
by Max
|
1 |
132 |
|
|
How do I circle a number in excel by
Dan Butler
When I type in a number that is less than a specific number set in
conditional formatting I would like a circle to appear around the number.
When I type a...
|
|
1 |
132 |
|
|
|
|
6 |
132 |
|
|
lbs ounces grams by
mjc
hi all
please can anyone help me.i'm trying to sort 3 weights in lbs
ounces grams. all i need help with is for excel to pick the two biggest
weights and
add...
|
May 2nd, 2006 05:03 PM
by mjc
|
6 |
132 |
|
|
Transferring Information by
Freddo
Ihave a spreadsheet which is comparing the information on the spreadsheet to
another spreadsheet via an Array Formula, if the information can not be found
I am...
|
May 5th, 2006 10:11 PM
by kassie
|
1 |
132 |
|
|
|
|
1 |
132 |
|
|
CELL function. by
Luiz Rapolla
Does the CELL function works with a external file?
I want to get the path and file name for a external file, but the CELL
function works only the active...
|
|
4 |
132 |
|
|
|
May 19th, 2006 01:44 PM
by jay d
|
8 |
132 |
|
|
|
March 31st, 2006 03:35 PM
by Ivano
|
5 |
132 |
|
|
How can I count conditional blank cells? by
Bruce Henson
I want to count blank cells in one column where a certain value exists in
another column. DCOUNT and COUNTIF don't work for this purpose. For
example, I...
|
March 29th, 2006 04:10 PM
by SteveG
|
2 |
132 |
|
|
cell properties and cell functions by
Steve Curtis
Is there a way to do basically a reverse of the conditional formatting -
where the certain cells have a pattern assigned to them already, and is there
a way to...
|
|
7 |
132 |
|
|
Scenario manager and IRR by
PeterW
Hi All
Does anybody know why the IRR formula doesn't appear to calculate when
it is one of the output fields under the Scenario Manager Pivot Table
option?...
|
February 15th, 2006 02:04 AM
by PeterW
|
0 |
132 |
|
|
Round hh:mm:ss to whole hh:mm by
PJH
I am using the following:
=TEXT((J30/$B$31)/24, "h:mm")
to convert hours and hundreths to hours and minutes. Excel is dropping the
seconds and not rounding...
|
|
3 |
132 |
|
|
check box not working on excel spreadsheet? by
Lissette
I need help with the check boxes on my excel spreadsheet at the top of the
sheet I am able to check mark them as I reach the end of the sheet for some
reason I...
|
|
3 |
132 |
|
|
column text merge by
publicx2001
hi-
i have 3 columns (A, B, C) of data with 100 rows in each column. i want
to combine my data from A,B, and C into column D. i can place this
formula into...
|
|
5 |
132 |
|
|
Excel - Euros to U.S. Dollars by
Tricia
How can I change Euros to U.S. Dollars in Excel 2003? I found how to convert
currencies but not Euros to Dollars just Dollars to Euros and other
currencies.
|
|
2 |
132 |
|
|
Format numberformat Single by
BenCoo
Hello,
In a sheet a have the following function :
Public Function feetAndInchToMeters(feet, inch) As Single
Dim sngFeet As Single
Dim sngInches As Single
Dim...
|
|
1 |
132 |
|
|
|
|
1 |
132 |
|
|
|
|
1 |
132 |