When I name a dynamic data range and use that named range it the data
validation, the error rotection goes away and it allows me to enter data not
on the drop down list.
Any ideas here?

Data that looks like this
Account  May June July ...
1              $10  $15  $22 ...
2              $12  $8   $34...

I have road milepoints and the number of accidents at that milepoint in
format listed below. What I need to do is find the 10-mile stretch of
road with the most accidents. How do I have Excel go through and take a
number from the left column and sum all the accidents within a ...

I need a formula in excel to only output numbers greater than zero and
replace any negative number with zero.  The spreadsheet I'm setting up will
be used to controle inventory and when my inventory on an item is greater
than my par for that item it is ordering a negative number ...

I need to have VLOOKUP be able to look up first, a Purchase Order # in column
A, and then also the part # in column E, and then list the quantity received
from another workbook, that pivots this information. How do I give the
VLOOKUP 2 conditions?

I have a list of dates I review daily and want to be able to click on an icon
or button beside each date to update it to todays date and not change the
other dates.

I have a table with dates in row 1 and city names in column A, plus
another worksheet which contains the data I want to use in the main
worksheet.
I can do a VLOOKUP on the place names in column A to return the correct

I am calculating the net present value of annual payments over a 20 year
term.  The payment is received in the middle of each year.  Because the
payments are periodic does it matter which function I use (NPV or XNPV)?
I have run both NPV and XNPV functions and get the same result. ...

I miss that Excel 12 should have a possibility to add text annotations to
numbers as a standard function in the connection to MSAS in SQL server 2005
(as Business Scorecards 2005)
----------------

I have 2003 edition of office and using Excel.  I want to fomat the cells as
($1.00) but I only have the option of -$1.00 how do I add a format to
currency to read this way?

Does anyone know how to set this up?
I have a worksheet with multiple columns. Each cell in these columns
has a differnt value. I am looking for a formula to display in 1 cell,
the lowest value from cells in the other 3 columns. I have heard of an

I built 2 named range for search, for example,
  "ABC" = A1: D4
  "DEF" = A10: F10:
and let's say, if Z1 = 1 then A100 = "ABC" and

I clicked on something and now my original (one) workbook has opened as two
workbooks with the above listed extensions.  If I do something in one, it
will appear in the other. If I close out and re- open the workbook from it's
original state, they still appear. I clicked too fast ...

i have one columns of numbers which displays negative numbers in this format,
300-, this is after import from legacy conversion program. In Excel, how can
i  convert this negative format from 999- to -999.
Tks !

I want to track the date last changed of several cells, so anyone looking at
the information can easily see the last updated date.  I want the date last
changed to show in an adjucant cell.  I don't just want to use track changes.