Thanks to the wonderful help from the people in here, I was able to update
an excel file.  Now I hope everyone can help me again with two formula's.
There are 4 columns involved, 2 columns data is inputed and I would like to
automate the data to be inputed in the other 2 columns.

How do I create an IF function that allows me to work on a cell if the value
input falls within a range of values.
For example, =IF(A1=B1:B10,"true","false")

I have four duplicate match reports on the 'WK 1'! spreadsheet.  One is used
for each match between 2 teams each week.  8 teams total in a leaque. I was
wondering how to write an Index/Match function that would search the whole
sheet (rather than each match report within the ...

I have been using Office XP for sometime which contains Excel 2002.  I have
always used the Alt "E" and C to Edit and Copy a cell or the Alt "E" and T to
Edit and Cut a cell.  Suddenly, if i do the Alt E/C, it does nothing, if I do
Alt E/T I go to the Tools Tab.  

I have a range of data.  The leftmost column contains names, some of the
names being repeated in some of the rows.  I used advanced filter to extract
the unique names.  I find that always the first name is shown twice, once at
the top and again somewhere at the middle.  How to ...

I need to :
- Take a value on the same row as the formula
- Look-up that value on another workbook / worksheet
- Return a value in on the same row as the value in the other sheet

In column A I have a list of numbers that have many duplicates.  In column B
I have a list of numbers.  I would like to have a count of the number of
times the number in column b is in column A.  I am using Excel 2003
Example

I'm trying to set up a sort of filter so that I can pull information from one
main page.
         Room 1       Room 2      Room 3       Room 4
Chair     1                 2                                   1

I am working with a Risk List.  I have a column called Probability of
Occurrence and another column called Impact if Occurs.  Both columns are
populated with L, M, or H (for Low, Medium and High).  
What I want to do is to create a third column called Risk Score.  To

I work different times every week.I want to be able to total the hours worked
each day to include overtime for each week  automatically. for example day
one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is
$25.00 overtime is 15%+

I replaced an excel file in error.  Is there a way to recover the original?

I have a date in cell A1 I need the date to also appear in cell G1 as text,
formatted as dd mmm yy. Any thoughts on how this might be done?

I have a big problem.
Each time I use Vlookup for search in numbers, and those or formated as
general the sytem returns NA, and just changing the format does not works, as
I need to chagne it and retype all! but my table has 20 thousands for each of

I have seen this question asked but not answered.  I have a worksheet that
serves as a template; thus it is to be copied and filled in over and over.  
It includes a couple hyperlinks for navigation.  When the worksheet is
copied, the links point to the template, not to the new ...

I am looking for a cell to add each time two cells in two different collomns
meet certian criteria