Hi.  I need to perform the regression function for a class project...we are
building asset portfolios.  I watched my professor do it in class, and it
seemed so easy.
I downloaded the add-in, "Analysis Tool Pak." From there,  I do the

How do I use the last total of a running balance in another cell?

I'm not sure if this is possible or not. I have a spreadsheet that makes
calculations based on the distance between two zip codes that are entered by
the user. Right now I'm using a table listing each zip code and it's latitude
and longitude, and a formula for the distance ...

WHAT CONVERTER DO I NEED TO IMPORT QUATTRO  .QWP FILES INTO EXCEL 2003  OR
DOES IT ONLY DO QW1 - 2 -3 ?

I have exported all my monthly invoice details into excel where it shows
different products and different selling prices per unit for each invoice.
This report is relatively huge and I would like a summary that shows  there
were 300 invoices for product X at selling price of $ 10, ...

I am having difficulty hiding rows with a zero sum value because I have a
break in the sequence. In other words, I'd like to hide the following rows
C8:C88 and C106: C180, but because there is a break in the sequence I am not
sure how to re-write the below Macro. Any assistance ...

hi ...plz help
given :
     C
5   tea

Excel 2007.  I know you can turn the symbols on and off using Excel Options /
Advanced, but I could swear I have seen somewhere a shortcut key combination
to do this much more quickly.  I've scoured local help and come up short.  
Also can't find any reference to shortcut keys ...

Is it possible to obtain just the year in B1 out of a whole date in A1 ?
I need to use the date in A1, in order to get a year, just THAT year in B1, in
order to get a result in C1.
It is complicated but the whole date in A1 I use it for 2 other purposes.

I have two workbooks; I want to look up the value in column 2 in one workbook
and put it in column 2 of the other workbook.  I am matching the values in
column 1 in each.  When I fill down, I get the exact same answer.  My auto
calculation is turned on.  Here is my formula:

I have an Excel 2003 worksheet with some content.
One column - or more prceisely a couple of cells) should be displayed but not printed (on paper).
How can I achieve this?
Or alternatively is there a way to temporarily hide a range of cells in visual sheet and printed version?

I write a macro,  there will some data copy from a sheet1 to another sheet2,
and then , the sheet1 will be closed. while the macro is running, there is a
message to ask me some data in clipboard, will I use it. I will choose "NO"
manually everytime when the macro running.

how to use the advanced filter and its options ???

Excel2003
I can't seem to get the correct syntax to get this to work.
The Process Runs New sheet isn't filtered by cbPMSelect even if a value is
input.

I want to create a macro that will allow me to use a shortcut that will:
(1) copy the values & the format (i.e. not the formulas) of the active
worksheet to a new workbook; and
(2) save that new workbook as "Claim" in a specified file location.