There is a simple function in WORD that allows you to change the case of
highlighted text. Why is'nt that function available in EXCEL? Point and
click, simple...
----------------

I want to find the occurence if it falls between a range
EG
Name  Brth DT
Tom  1/1/2005

If column A="TMT" then I want it to go to column h and pick up the value.  
How do I set this up?

My previous question perhaps was not worded correctly.
What is the specific text for using the count of countif funtions with two
criteria with both criteria to be met for the cell to be counted example
Countif A1:A5 equals f AND D1:D5 equals 0

A coworker tasked me with finding this out:
Either by formula or by code, how can one return the color code for a cell?
What he wants to do is be able to say something to the effect of "IF cell a2
is GREEN, then add a2+b2, ELSE IF cell a2 is RED, then..."

=SUMIF(A7:A100,">=12/04/05-<=14/04/05",B7:B15) what am i doing wrong

I am creating a five year cash flow table. Months from Jan 06 to Jan 10 will
be along the top and long running construction projects will be listed on the
left hand side.
The variables associated with each project are

I have been asked to work on an Excel spreadsheet to search for information
on one sheet by using dropdows on a 'User' sheet.
The result of using 3 separate dropdowns will show the results in the cells
directly beneath the pulldown boxes on that same sheet.

I am looking for a way to parse the examples below in excel:
124 A  into 124
12345  into 12345
55/49  into 55

I have a list of unique records in a spreadsheet. Each record has a
value of either "open" or "closed".  I can get the total number of
unique records by doing a = SUBTOTAL(3,A2:A999), however I need a
similar formula that can count the number of unique records + count the

When I bring up the formula box for the following formula (attempting to sum
up numbers in a different sheet given various conditions) --
=SUM(IF(Sheet1!F2:F1900='1340 - 001'!B8,IF(Sheet1!D2:D1900='1340 -
001'!C8,IF(Sheet1!C2:C1900='1340 - 001'!F8,IF(Sheet1!G2:G1900='1340 -

I need know, whether there is any formula in excel, which will merge
two or more cell?
Can any one help me in this regard..
Thanks,

Is there a way to protect individual cells?  Thank you
--
amos7
-----------------------------------------------------------------------

In this formula: = b24/b5
If b5 is blank or zero, can the formula be written so that it will return
"NoOrders" ?
Thank you in advance.

I have used this formula
=INDEX($AF$7:$AN$14,MATCH(K22,$AE$7:$AE$13,0),MATCH(L22,$AF$6:$AN$6,0))
Works great as long yoou have responses in k22 and l22 but if those are not
yet filled in i get a #N/A  is there any way to return a blank unless there