I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between  days on, off and at the other ...

I have created a web page (site) in Publisher and want to import it into
front page. howdo I do this? the import option doesn't work
Mike

I need help using ISERROR to ignore Div/0! values in a list of cells I'm
trying to average. My problem is that when I use ISERROR to replace the
Div/0! with "" I now get a #Value! error instead. Here's the steps I've
been following:

Hi there everyone,
This seems such a simple problem, but its driving me up the wall! For some
reason 'repeat last action' (Ctrl+y) doesn't work whilst I'm recording a
macro (trying to repeat paste special).  Macro security is set to medium, and

Quick question:
I know about the index match function, but don't have a clue how to write an
expression for it.
I have 2 work sheets: NewCrib and OldCrib. On each I have a PartNumber

I have a spreadsheet with branches and survey answers to calculate.  I
want to only count the cells containing text in a certain range for
each branch.  The formula I'm trying to use is =counta(if(a2..k58="Port
Malabar",j2..k58)).  I keep getting a value error.

I have a spreadsheet and I need a formul to calculate a sum based on
various criteria and a count of unique entries based on criteria.
My current formulas are as follows:
SUM

I have entered a time value 27:00 in cell A1, with the following custom format [h]:mm:ss. I want to construct a test that will
return "True" if the A1 is more than or equal to 24 hours, and "False" if less than 24 hours. I know this will entail the use of the
"IF" function, which ...

My problem is that I can NOT get the function =NETWORKDAYS to operate!
I had a workbook with a worksheet in it with data from the previous year
working well with this function.  I copied, then renamed the workbook, opened
the relevant worksheet and the function yields the error ...

I have copied down a currency table, from
http://www.oanda.com/convert/fxhistory
The dates are in the US format
09/04/2005

I have an excel document that i would like to place on a server here at
my workplace that, each time its printed it places a serial number on
the printed sheet starting with the # 6000.
Im pretty clueless with fomulas(ive tried and tried).Any suggestions

A sample of the data I'm working with looks like this:
                                                  Formations
    313**    313**313**    317**    317**317**   
TSC

I would like to set up a formula to remind me of a meeting in the future for
clientel of about 100, different dates in the future over a 6 months period.
If not using an excel package, maybe using a next package.
thanks

Excel 2002

Please pardon the reposting, my original got a lot of discussion, masking the
lack of a final solution.
On sheet1 I have a column with multiple names.  I need a function (in one
cell, on a separate sheet) that can look up all those names from column B of