Hi I would like to add a drop down list for the all the
names of CDs that i have. Does anyone know how to do this?
Thanks in advance.

I have a spreadsheet that I use to keep track of works in
progress.  I would like to create a column that date &/or
time stamps when an adjoining cell is updated.  
Everything I try results in the time changing every

I'm trying to write a user-defined Function, so that I can put data int
other (existing) spreadsheets, and read data back from other cells i
that spreadsheet.
I have a number of spreadsheets that do useful things like calculat

does anybody know how to use DSUM Workfunction without
passing a range as a criteria. I mean, I'd like to use something
like that
=dsum(range,"quantity","number > 1")

I have an array (A3:K100) that i'd like to extract rows from.
Specifically, if J3:J100="Discontinued", I want to list all of these
rows (and all of the row's contents from A to K) on a different sheet.
I've been able to get an array with something like

I need to count the number of cells where the date in the a range of
cells is is equal to a certain year. The cells are formatted as a
date.
Example:

Given a grocery store price list (=A1:B7):
ITEM:   PRICE:
Apple   $0.33
Honey   $2.25

I have this formula:
=IF(C36<(C4*0.1),"First payment must be at least 10%"," ")
I would like it to read:
=IF(C36<(C4*0.1),"First payment must be at least {result

I am trying to keep accounts for two investment properties. I have found 'balance sheets' in the excel section, but am at a loss to how to use this.  I have filled in one, but have no idea how to go to the next page. I see a heading which says 'workbook' so I am wondering if I ...

can anybody help me with either to extend the limit of "IF" funtions
in a statement from 7 to a minimum of 10 or alternatively help me with
a work-around! It is to messy what I have come up with and its not
working proberly.

Excel LINEST returns the list of regression coefficients in the
REVERSE order of the columns of independent variables. Why on earth
did Microsoft do this? Is there a way to order the regression
coefficients consistently with the columns of data?

I have a list of 600 so addresses imported from somewhee
or another.  Several hundred are from new england so the
zip codes, which start with a 0, are now displayed as 4
digit numbers.  

When I refresh a pivot table, the pivot table field "Date"
keeps old dates in the pull down list box. How can I get
rid of these Dates that carry on. List keeps growing and
growing even though the data is no longer there.

I have Excel 2000 and I want to be able to assign a list
of varialbles with the data posted at the top of the
worksheet.  But I want to be able to input the varialable
into cells and have the ability to change the value in the

I have this problem to solve:
in A1 is int number from 0 to 6
in B1 is a value 1000
there is a separate table with "limits" such as