Hi and thanks in advance for any help provided.  I am trying to simplify a
nested if statement formula that sums columns of data based on the number in
another column.  Here is an example:
Weeks to Sum     Wk1     Wk2     Wk3     Wk4     Wk5     Wk6     Wk7     Wk8

I am trying to create a 3 dimensional matrix. The following is an example.
I am trying to distribute $100,000 amognst 234 employees equitably amongst 4
levels, (VP, AVP, Director, Manager) based on 4-Performance Ratings, (1-
Excellent, 2-Very Good, 3,-Good, 4-Fair) and based ...

I make weekly budget reports, and I use a PivotTable to get a basic overview.
Now the problem is that as I extract data weekly, it changes and rows are
added to the original data each time. The PivotTable does not recognize this
and only checks the original field range. How do I ...

I am trying to limit the amount of numbers that are in a cell. For example I
have a cell that has this sort of number 1220H123456, and I only want to have
the last six digits in that cell so I can sort in a numerical order. I have
been deleting the first 5 digits manually, but ...

The notes for LOOKUP function indicate the values in a row must be sorted or
invalid results will occur.  Is there a way to get around this?  How can I
use the LOOKUP function or any other lookup function to correctly return
results on an unsorted row of data?  Below is an ...

Here is what I need to do:
Column G contains a claim number. L contains a combination of letters
and numbers, its a code, like v3.7 etc.  Column M contains a code, a 4
digit number.  Column S is paid amount.  T is Overpayment.  Column U

I have a spreadsheet that has been formatted from a Crystal Report.  There is
a vertical text line at the right hand side of several of the cells.  I want
a quick way to remove these lines so that the data can be copied and used in
formulas and macros.

I've got a worksheet containing data similar to the following:
Name1          Name2
Mark             Sharon
John             Tracy

Hi, I have a situation similar to D. West where I'd like for the current
time and date to be entered in col. A whenever a new row is populated with
values. I tried the setting col. A to: =IF(COUNTA(B3:IV3)<>0,NOW(),"") like
Gary Brown suggested for D.West. That sort of worked, ...

   a    b      c             d
1  .2   yes   yes         .3
2  .5   no     no         .5
3  .1   yes    maybe   0

I am working on the following formula that returns 0 as the answer but when I
review the formula bar it has the correct answer?  Is there anything I can do
to display the result in the cell or am I overwriting the calculation with
the 0 for the false statement somehow.  I have ...

I am trying to fill in cells in one sheet with every 6th cell from another
sheet. I cannot get the fill feature to increment every 6th cell on the
reference sheet.  Help! When I drag the handle it increments by one. When I
click on the fill button and type in 6 then OK... it ...

I have a problem I am hoping someone can help me with. Here is what I am
calculating:
A = Work Completion Date
B = Fixed Price Date

hello all,  i have a row of 18 numbers that update autmatically and give me a
number increasing by 1 if the statement is true, if false, i get a 0. i would
like to know of a formula that will give me the last number in the string
excluding the 0's.

please help a desperate financial analyst out!  i have a data table with
three columns: date, num of shares, and dividend per share.  i want to create
a simple calculator that performs a sumproduct of num_shares times
dividend_per_share for a specified date range.  the idea is to ...