Greetings All,
I have the following array of data, column 1 is the date and column 2 is the
amount in US$. I am trying to use regression to forecast three years or so
hence.

I have 3 columns for 'complaint A',  '..B', '..C'.   Each of the cells in
those columns has the same drop-down list that contains 5 items.  What I want
to do is have the item from the drop down list moved/placed automatically
into a new cell, but I want the other two drop-down ...

Yes it's in module2 under the Modules folder on the left side in the Visual Basic Editor

I have 6 months of actuals and I need to throw out the month and the low
month then take the remain 4 months times 3 to come up with a years total

I have as an example:
Columns
A                                    B
apples----------------------2

Hello again
I seem to remember someone saying that you could put all your functions in
cells that are hidden way down in the bottom of a sheet somewhere so that
knowone could delete or mess with them. and they would still perform the

want to get price and qty from my broker acct into my long time excel
spreadsheet. Can "export" all stocks, funds into excel using their program
which gives me a new spreadsheet with all info. I put = in my own sheet cell;
go to broker's sheet and highlight cell, go back to my ...

I am trying to correspond a running balance on a sheet to correspond to a
master sheet of totals. I am creating a budget workbook in Excel 2003 with
the feel of envelope budgeting where I create multiple "envelopes" (using a
check book register template) and I distribute monies ...

Hello everyone...n00b question.
I'm using Excel 2003 to split up a daily spreadsheet between me and 2
of my peers. We split the orders based on the last 2 characters of the
order. The orders are all 7 digits and all numerical. Exp... 3215453.

there is a limitation to use any function with 7 nest. but i have to use 100

I have an address list in one worksheet with: Last Name, First name, Address,
City, phone No. These addresses are sort alphabetically by last name.
On another worksheet I am attempting to match data from the first sheet
using the VLOOKUP function.

I need to get excel to enter to-days date and then freeze this date so is
does not update later. I dont want to copy-paste special-values.  I need to
have it in a function statement.
I tried   =IF(C17="not completed","",TEXT(TODAY(),"d/mm/yyyy;@"))

I have a total kw (kilowatt) of 1400110
I have a group of building that have each a portion of this.
Each building is different one is 55973kw another is 32034 and so on
How do I figure what percentage of the total kw each of the buildings

I need to create a formula that change the reference of a sheet when i copy
the formula.
I have the formula: sumif(sheet2!$F:$F;"Total Rota:";sheet2!$H$H)
When i copy the formula for the next rows or columns, i want the reference

I have multiple spreadsheets that I want to sum them up on one main
"control" sheet, so I can get a grand total payroll figure. How can I do
that? Any help would be appreciated.
Thanks,