I cannot see the "Data Analysis" option under the Tool Menu in Excel.
I would like to know what i am missing. what do i need to install to have
this option and be able to use its functions.
how can i get any file (.dll) that i may need

a while back i used to have Goal seek, for some strange reason it
delted from the Tools option. When i go to back to search for it i
can't find it. I try many things to look for it for no look. Is there a
way to add in Goal seek to excel 2003?  anything will be great.

A                   B            C
8/1/06           8/1/06        2
8/2/06           8/2/06        1
8/3/06           8/3/06        2

I am making a spreadsheet where I am inputting a large list of
different numbers - I want to put a check in to make sure no number is
input more than once.
What would be the easiest way to do this? (ideally a column to the

For some reason, this feature has become unreliable recently (in the
last 3 to 4 days).  When I use it I often get very large negative
numbers.  I went back to old spreadsheets that I know worked at one
time and they don't work any more either.  My associate thinks it's

I can make a formula to add up 10 + 10 and it will not calulate it for me.
Nothing works. I've been using this spreedsheet to keep up with my bills for
years and it just stopped working today.
What should I do? Thanks,

Dearest Wizards,
Typical work schedule here.  Employee’s names in Col A, Dates of a 4 week
period on Row 1.
What I want: Row 2 to have the number of WORKING employees on for that day.

Okay, I think the best way to do this is to have me explain what I'
trying to do.
Next year I'm living with 5 others, and I want a sheet to calculate ou
living expenses, and to figure out how much we owe each other.  I hav

I am trying to find a value of a cell.  I keep recieving error messages #Name?
If I19 is yes then I want it to calculate a value using (D15/52)*60%
If I19 is no then I want the cell to show"0"
IF(I19=yes,(((D15/52)*0.6)),"0")

I have a monthly spreadsheet - columns consistent but number of rows and
cell content not - that I need to link to a standard analysis sheet.
I've been trying to use dynamic ranges and offset formulae but am getting
unreliable results. eg :

I need a formula that will display which period a set of dates belongs to.
The info looks like this, located in a sheet named 'Period Dates'.
Period       Start                         End
Period 1    01/04/2006    28/04/2006

I'm trying to develop a spreadsheet that projects dates due and highlights
that date when it arrives (maybe in another color).

I have an input file that I would like to get into separate cells.  The
data is something like this:
George Bush123456-78902
Abe Lincoln9876-543210

1.  I would like a TLookUp Function like VLookup which is for text.
2.  I would like a =ASCII(number) / =ANSI (number)  to convert numbers to a
letter / sign
The TEXT function which converts a single number to a letter is not good

I have a worksheet containing about 150 columns with data and in the last
column I sum up data based on requirement. ( totaling of every 3rd column
like C10+F10+I10+L10+O10+R10+U10+X10. When I insert one or two columns I want
that particular column included in the formula. Is it ...