I am using Index Match Function to find specific employees hours and copy the
hours to into another worksheet.  I copied the file and renamed it and now it
will not pull the new hours.  What am I doing wrong?

I have a small problem what i want to do is have excell subtract 8 fro
a cell only if the value in that cell is greater than 8 in other word
i don't want any negative numbers to result from the formula s
basicaly

Is there a way to make a comment indicator for a cell always show up on the
left side of the cell instead of the right?

Good Afternoon ...
This questions is probably redundant, however, my question is how to write
the formula to count, and excluding certain criteria.  For example:
Column A

can anyone help
I would like to return a result based on the following scenario
If cell A1 <10% return "0" or if cell A1 >10% sum would then = cel
A3-A4

I have a problem with Excel's iteration function. I have created an
extensive model to simulate the investor's IRR under variable scenarios.
Changing the scenario results in a re-calculation of the model. But when I
select a scenario which I had selected before already I get a ...

I have a bunch of data that is in the following format: hours:minutes:seconds
For example:
3:23:14
5:20:45

I have a "master" file that several workbooks are linked to.  Each individual
workbook is password protected.  I would like to be able to open and update
the "master" file, however it is asking me for every individual password.  
This will not work.  Is there a way to "override" ...

I have an invoice template in Excel.  I want to set up a mail merge so that I
can include data on name, address etc. in the invoice.  The merge data is
also in Excel.  Is there a way to set up a mail merge in an excel document,
using an Excel data source, or do I need to do ...

I have created a data sheet in Excel that has pull down menus in many cells.  
The font size is so small that I can't read it so I am looking to increast
the font size for the pull down menus to something I can see and read.

I'm attempting a countif that reads - COUNTIF(A:A,LEFT(A:A,1)=X)
Where column A looks something like:
XYZ
MNOP

I would like to create a formula that would calculate the length of a
person's employment, i.e. hired 8/14/94 till today, for example.  Any Ideas
will be greatfully accepted.

I want to calculate the % difference between actual and goal for the month we
are in.  i.e.  J1=I1/C1(when we are in Feb), or J1=I1/E1(when we are in
April).  In other words, the answer for J1 will reflect whatever month we are
currently in.  If you open up the spreadsheet in ...

I'm trying to write a statement macro and one of the cells is a
comments section where it evaluates other cells in the row. However,
I've exceeded the number of IF statements by one:
=IF(A3="","", IF(COUNTIF(S$3:S$20000,A3)>1, "Duplicate or secondary

Using Excel 2000 I would like to incorporate a macro which allowed the user
to select the first cell in any column of sorted data and then compare each
entry and remove any duplicate lines. It would continue to do this until the
next cell in the chosen column did not contain an ...