I have a sheet that shows when an item was logged out (i.e. maintenence) and
when it was logged back in. The sheet calculates how long each item was
logged out. Now I want to calculate the average outage time for all items
listed.

I am try to calculate semi annual masks in a model.  My model has a switch
which turns the model into 1 of 4 modes (Annual, SA, Quaterly, Monthly) - the
first series.  I want to be able to calculated the SA (Semi Annual) Period
Counter in all four scenarios.  So when the first ...

I have 3 worksheet and I would like to have certain cell copy into a master
sheet.
So, when you enter a number into "sheet 1" in places it into "master" the
cells are not in the same exact spot. Is there a formula to make these cells

I have my list of Criteria in Column A - (In this case the Criteria are names)
In column B, C, D, and so on are days of the month.
I paste the raw data underneath the spreadsheet in the coresponding columns.
So, day 1 is under column B. Day 2 under column C and so on.

I'm currently using Excel 2003 and have created several templates with hidden
formulas, shaded cells, and borders. I would like the user to be able to copy
the text in the cells without copying the border or shaded color. Is this
possible?

I have the following Index formula which is not producing the correct result
and I am unsure of why
{=INDEX(StartTime_HoursWorked,MATCH(1,(Date_HoursWorked=H$9)*(StaffNo_HoursWorked=$B$13)))}
My named ranges are using the Offset formula, all worked off

Column A is the number of shirts ordered.
Column G is the name to be printed on the shirt(s)...(if wanted).
Column H is the total cost to print the name(s) if wanted (@ $6.00 each).
How do I get the cost (Column H) to fill in based on if there is anything in

I have a table with a list of names and matching vendor numbers. I want to
create a macro or formula that takes an input entry cell "say CHI" and would
give me a list of all names in the table (Chicago, Chicago White Sox, Chicago
Bulls, City of Chicago etc.)

Please help

I am trying count count the number of occurances of  a value = or > than
(E7+2) but cannot workout the syntax. Can anybody kindly point me in the
right direction?
=COUNTIF(E13:E15,(E7+2))

I have large columns of data (4000 to 5000 entrys)  I would like to thin the
data out or reduce the number of samples by building a new column of groups
of  average values.  For example:
3    reduce by average groups of 3         3

I want to create a list of dates one month apart from cell A1 thru
A200.  In cell A1, I have the date of April 1, 2006.  I need a formula
that copies A1 and adds one month to cell A2 thru A200.
Example

Column D is a dropdown list of shirt sizes from S to 4X.
I am trying to get the price to show up in Column F, depending on what size
appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
are 19.75. I got this formula to work for one size only:

I have used vlookup on many occasions without any problems, however, to day
for some reason it is not working.  Below is the look up range and I want to
return the value 5.810, 3.410 ... in another table.  I am getting N/A#  Is
ther something I am missing.

Have a large spreadsheet, need to move certain cells in one column to another
column.  Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"