How to search for all the start dates for Phase="Performance Testing"
Phase                                       Start date  
System Requirements Study    11-Feb-06
System testing                            13-Mar-06

I could not find the auto fill Option button on my excell. The class I take
right now I have to copy the formular from one cell to the rest of the cells
in the spread sheet . I follow the instruction of using the fill handler
pointer and highlight  all the cell that will have the ...

I converted a large Lotus 123 document into excel, now whatever date I enter
returns a 1/00/00 date, in whatever format I choose..Jan 0 1900..1-0-00 etc.
the correct date is displayed up on the F line but in my sheet is says Jan
zero of the year 1900...It has successfully driven ...

For years I've been regressing vapor pressure data with a 4 parameter
equation in Excel using the built in matrix functions.  From this
group, I learned that I could perform the same regression using the
LINEST function, which would clean up my spreadsheet a little bit, and

I'm importing comma delimited files into excel.  I would like to set the
import wizard settings so that it is always "delimited" (rather than "fixed
width") and "comma" (rather than "tab").  Is there a way to do this?
Thanks

On one of my worksheets I type the day of the week in the first column,
followed by the date in the second column etc.
Since the current entry is in line 3,675th when I typed the first letter of
the day the rest was completed automatically. E.g. If I typed M then onday

Excel 2002
In a text cell that is formatted to automatically wrap text,
how do you get a hard return in to force a new line?
Thanks

This is what I am trying to do....
1. When someone clicks on cell, the checkmark symbol is entered into
the cell
2. When someone clicks on the same cell again, they cell becomes blank

I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.

Is there an easy way to copy multiple values and paste the sum of these
values in one cell. So, I select the values of A.1, A.2 and A.3. I copy
the cells and wants to paste the sum in another worksheet.

eg. if c5=3
     a[c5] should give me the contents of a3 like in any high level language

I am new in your forum, I have posted a question and it says i am not
group member of forum. Tell me what it is and how to get group
membership.
By all means my question was how to pastelink a cell with existing

Rule for nested IF statements is 7 as seen below. Since most of the
results in my formulae are TEXT is it possible to put these in to an
array IF statement.
=IF(AND(B5="",C5=""),"",IF(B5="ATM","Petty Cash",IF(B5="BC","Bank

Any help is surely appreciated.
I have a sheet where col.a represents expenses, col. b represents numericaly
coded reasons for the expense ie: 1,2,3 - owner request, error, unforseen
conditions etc.with a legend shown elsewhere.

there are 3 teachers in a school. Ann, ben and carl. Ann teaches math and
history, ben teaches math, history and science, carl teaches math, science
and drawing. suppose cell a1 contains a drop down box containing the three
names (ann, ben and carl). if i select ann in a1, cells ...