I need to use a vlookup and sum function (I think) in an Excel 2000 workbook
with two worksheets.  The Update worksheet shows client ref in column A, then
along each row, shows various monetary values of business done by each
client.  The Summary worksheet also shows the client ...

I thought I saw a posting a couples of months ago about having a pivot table
update the underlying data and now I can’t find a reference to it. Am I
dreaming I saw it ?

Our industry bills parts of an hour, ie .1 = 6 minutes or .5 = 30 minutes.
Trying to calc things like 25 X .1 = 2:30 or 2 hours 30 minutes
A1=25, B1=.1, C1=?
What should the formula in C1 be & should the cell be formatted somehow ?

How do I modify this:
=LOOKUP(2,1/(A1:A10<>""),A1:A10)
which looks up the last value in a column so it instead retrieves the second
to last value in a column, third to last value in a column, fourth to last,

I have the following Dataset
Month    Region    Amount
Jan        East       10
Jan        East       7

Below is my question,
I need to have 2 rows inserted for each cell I have in column "A".
Serial #                  RESULTS
5877-0101-6090    5877-0101-6090

Im am trying to create a purchase order for the sales guys in my office to
use.  I want them to be able to have the purchase order on there desk tops
and be able to add in the "company name" in the "compnay name" feild without
changing or the verbiage in the field.  Example:  ...

I'm trying to come up with a formula that will sum the values in any of these
columns based on the year column.  For example, I have the following formula
that sums the values in the Create column if the Year column = 2002.  The
second part of the formula needs to then count how ...

Ive got some 'scores' to put into excel. For each score, a set number of
points is awarded.
Score - 0-5 - No Points
    6-9 - 12 points

Ive got some 'scores' to put into excel. For each score, a set number of
points is awarded.
Score - 0-5 - No Points
    6-9 - 12 points

I  am trying to highlight all the same strings in one Excel cell.
For example, if the following text in one Excel cell,
Wish you all a wonderful wonderful weekend!
Using Gord Dibben's macro posted on Sep 19 2006 in this group (Please

I need a running count at the top of a column of single text vaules in a
column once sheet has ben filtered.
eg: need running count of number of W's if I filter by pairs 1 to 5 only.
Cable    Pair #    Type    Status

I have a spreadsheet that is similar to below:
A             B C D E F G H I J ....
January    1 2 3 4 5 6 7 8 9 10...
              a a b b b a b b a b

I have the following data and am trying to copy the sum function to create a
running total.  When I copy the formula it keeps the same column and I need
it to jump to the subsequent column.  Assume this data is in columns A and B
starting in A1.

I need to calculate the present value of an annuity where the base payment
increases by a fixed percent each period, thus compounds on itself each
period.
To clarify what I mean by compounding on itself: e.g. payment increases by