I am looking for a formula that will return all words except for the last
word.
   Eample:. in cell A1 I have: Castleton Parkway Blvd--I want to return in
cell A2: Castleton Parkway

I have this function in a particular cell;
=IF(D55>0,IF(AND(E18=1,D14<26),6,IF(AND(E17&E18="10",D14>=26),"0",IF(E17=1,IF(D14<36.344,"0",IF(AND(D14>=36.344,D14<39.549),1,2)),IF(D14<37.11,"0",IF(AND(D14>=37.11,D14<39.174),3,4))))),0)
I need to add the following to it, and I can't ...

Could anyone help me in solving this problem.
I have a dataset in one column (G) containing only numbers. Every nth
row in that column is empty (so it varies). In this empty cell I want
to calculate the average of the n cells above. n is defined by the next

Hey everyone, first let me say this group is great.  I've found a lot
of great resources here.  I'm working on a spreadsheet and have a 3
columns with values down the rows.  Not every row has values in it
though.  I want to be able to get the average of the first 9 values I

I have one known series with a polynomial-like trend. I would like to
create a second series with the same X values but Y values for which
only the minimum and maximum values are known. The values in between
would fit the curve of the first series. Is there any function that

i have the following case:
DATE        Ammount
01.12.06    50
05.12.06    100

I have a range C6 to AK6 where some have x's in them.  There are five
groups of x's.  R6 to T6 is the smallest group.
I'd like S6 in the group to turn colour if, any cell in C6 to AK6
matches it (has an x), except the cells in it's group (R6 to T6).

Is it possible to have a cell value adjust depending what is typed into it?
E.g. I want to be able to type A or B or C and have the value of the same
cell change to Arnold or Brendan or Charlie respectively.
Sandy

I am trying to find a solution on that but i cannot. Does anybody is
able to help me? What i need is to define Dynamic Ranges of values
(column B) using non-contiguous cells values (column A).
Please find attached a relevant discussion on the topic dating back to

I was putting a slightly modified version of this function into cell
B12, in doing so it occupied cell B12 and B13 and merged the space
together.  This happens often when I am using functions, how can I make
sure it only takes up one cell address?

How can I change print set up settings, on all tabs on a worksheet?
I can do it from print preview, but it only changes the set up for the
active sheet.
I have a workbook with many tabs, and there must be a quick method to set up

Is there any way to solve to quadratic equation is Excel?
I want to do it one cell and then copy it all down in the spreadsheet.
Thanks.

I have five excel sheets being filled up by five different managers for
monthly attendance of staff alloted to them from time to time.  On the month
end I need to merge all these data in one sheet and produce a consolidated
report on the attendance status of each staff.

How would I display the value of OpCount in S5?
ElseIf ActiveCell.Value = "OP" Then
           OPCount = OPCount + 1
from my module into my existing workbook cell s4?

Bernard,
That was exactly what I needed on Sheets 1 to 3 of your response.
Thank you very much for your time and efforts
Saruman