I have a column AB (accum hours)    on sheet I and it calculates a sum for
the previous 8 weeks (ie sheets A to H) which works fine, but when we copy
the formula on to the next week (sheet J) it stays the same when we need it
to calculate sheets B to I, and so on for the rest of ...

=IF($B2="","No EIN to Match", INDEX(business,MATCH($B2,EIN,0)))
At first this formula worked fine and then it just kept have more and more
problems
what is wrong?

I have a number of lists in a single column, each list is separated by
a blank row.
Is there a formula that will display only the first and last item of
each list separately? In other words, each list needs to have its own

I am trying to get a formula from
http://xcell05.free.fr/english/
to work, but I keep getting 'FALSE.' This is
my formula

Hi! I have a large matrix. Some of the cells contain the value 0. I want to
get a new clean matrix where all 0 cells are removed. I then want to change
the matrix into a long column. The cells that contain 0 shall be removed and
not just replaced with another value. Is that ...

I need to find the formula that can match a specified monetary value to a name.
For instance if I type in A1 Name1 then in B1 $14.00 comes in or if I would
have typed in Name2 then $18.00 would pop in.  I need this calculation to
automatically pop in someone's hourly pay by what ...

PRODUCT DESCRIPTION                   
3X5 RAS PAD    18X5 RAS PAD    18X18 RAS PAD    RAS SOCK    E/C CHARGE    DELIVERY
P.O. PRICE    P.O. PRICE    P.O. PRICE    P.O. PRICE    P.O. PRICE    P.O. PRICE
$2.70    $2.00    $1.00    $1.00    3% OF PROD.    $20.00

Dave , Thanks very much. I'm a first time user here, so forgive my ignorance.
The answer you gave fixed my problem. Only that has lead me to attempt further
adjusting to someone else's excel sheet. If you don't mind, here are some
more questions.

Is there a function that will create a list of named ranges and their
locations in a workbook?

The default filters are no longer usable because when you open the filter all
choices are selected and you can only un-select one at at time. For a long
list this is impractical. Even worse, if you click a row you may accidentally
clear it's selection so the result will be all of ...

This is my expression.
=IF(M1="M",12,IF(M1="SM",24,IF(M1="W",24.2,IF(M1="BW",26.07,IF(M1="A",1)))))
The result is "False" for the "M","A", and "w". The results for "SM" and
"BW" are correct. (24 and 26.07) is there something wrong with my statement?

I have two rows; one is a row of years and the other is a series of negative
to positive values (goes from negative then positive) for each year.
i.e.
2002,2003,2004,2005,2006,2007,2008

What formula can I use to sum numbers in column f, if a="w", b="U" or "i" and
c="s". The sum shoud be 10?
a    b    c    d    e    f
q    a    b    w    10    1

i have a list created, with a lot of customers (its a dropdown list, where
you can roll to the desired customer). Is it possible to do the following: if
i start to write in the customer name; (let's say Hilton), than at Hi it
gives me the Hilton name already (of course if there ...

i am creating a workbook to track assessment details for my classes. As part
of this workbook i am trying to use a vlookup table to convert an assessment
level to a numerical value e.g. 4B converts to 4.33.
My lookup function works fine apart from any level that has the letter A ...