I have a table that I have turned into a list.  I narrow down the table
by choosing what to show in the header drop downs until I just have one
row of data showing.
How can I grab the numbers that are showing after I have chosen the

I'm trying to create a gradesheet in which any score that falls into the
failing range will automatically highlight in red...

I am trying to calculate the first derivative of a curve in excel to
determine the inflection point.  I know how to do this in Sigmaplot, but my
students only have access to excel.
Please reply to rgoyan@sfu.ca

I have been trying to search for the answer but can't quite find it.  I am
trying to do what I can only think of to call a two level lookup.  Basically
it requires to pieces of data to uniquely identify the record.  
In the example below I will have a record that contains a ...

I'm using Excel w Office 2000. Until today I have had no trouble inserting
scroll bars. Usually I right click on the control bar and go to format
control. Then I go to the control tab to set parameters. The Control tab is
one of 5 tabs (size, protestion, properties, web, control) ...

Is it possible to have numbers added to the same cell and have excel continue
to calculate the addition for me in that same cell......ex: I have the number
8 in cell d2 and I want to add the number 8 to that cell and have excel add
the 8 to the previous 8 for a total of 16 in the ...

If d1 - c1 > 30 then I want to change the value of F1 -
how do I do this?

I need help, my feeble mind cannot come up with a formula to match my 60 min
time clock.  I need to have a "form" that other employees can just plug the
#'s in and not have to mess with the formula or the numbers (ie: going from a
60 min clock to an 100 min clock)

i have a list to over 1000 contacts in column form. i would like to convert
these contact into row from. Microsoft lets you convert one group at a time.
If i highlight more than one group and paste special they come up side by
side on same line.

Hi there- there seem to be quite a few of these posts, but I can't seem to
get it.  I have the following:
Ref No      Object      Color
123          Pen          Red

I'm trying to use the following formula in conditional formatting in cell A2 when the range A2:AW64 is selected (this conditional
formatting will be copied to all cells in the selected range):
Formula is:  =isodd($A2)
The error I keep getting is this:

I'm trying to test if vlookup could behave in a way that I would not expect.
I have two tables, let's say table A holds unique individuals and their i.e.
social sec. numbers.
I have a table B, which lists individual coffee preferences. Generally, each

This is a two part question.
I have a table with sales data that I am trying to average and chart.
Each row repesents data for each month (36 rows one for each month for
3 years worth of data). The information is all being pulled from other

Hi, I have two database with the same column but different rows. Both
database contains $ amount for 12 months for different products. I want to
build one pivot table which compares the $ variance of the same product
category for 12 months. How do I do that?

Hi Group,
The Cumipmt function returns the cumulative interest paid given a set
interest rate, principle, periods, type and the time period you want to
cover. Does anyone know the algebra behind the function? And I am not realy