Can any one suggest a formula/code to work out the CAGR(Compounded Annual
Growth Rate)

Greetings all.  I know I saw the answer to this one recently, but I can not
find it now.  I have a workbook with worksheets linked to SQL2K.  I have many
formulas like =F6*$G$5.  I drag the formula down to one row below the last
row of data on the sheet, and everything works as ...

I am trying to do something I think is simple, but can't get it...
I am building a worksheet in which I would like to list data from the same
cell of each of the preceding worksheets.  For example, each sheet represents
a salesperson and cell A1 of each sheet has sales figures for ...

I have been receiving an error maessage that my worksheet contains one or
more invalid references. (Everytime a new data value is entered)  And that I
should varify that my formulas contain valid references .  The trouble is
that my workbook contains lots of formulas and I have ...

Hi, I'm using a webquery to import data into Excel. Some of the items
that are being imported have an asterisk in the cell, but in excel it
shows no asterisk. Problem is I need to see the asterisk in excel.
Any help would be apprreciated.

This is possibly very simple but for some reason I just dont get it. I have
3 columns
A    B     C
2    3      formula

While this formula works on another sheet, it doesn't work on this sheet.
Actually it works only on first cell. I have tried copy > paste special
formula, I also tried drag the formula down, but nothing seem to work. I have
checked the data format for each column, I even used ...

I am trying to use the VLOOKUP command but want it to return a cell address
rather than the result, i tried ADDRESS but to no avail as i wouldn't know
its position with the worksheet

I have an x and y data set for which I want to identify the parameters
(a,b,c) in the following second order polynomial equation.  What Excel
functions can do this?  I can chart the data and use the trendline function,
but I want to automatically calculate the parameters in ...

I am trying to create a command button that will run a series of macros.  
However the command button will only allow me to assign one macro.  What is
another way that I can run several macros in a sequence with one button.  
Instead of having to run them one at a time?

I have a spreadsheet that has MFG #, Manufacturer, Description and Unit
Price.  I need a formula that will look up and match at least the data in 3
columns (MFG #, Manufacturer and Unit Price) in another workbook and bring
back the quantity shipped for the row that matches that ...

Excel will not print with grid lines.  I've gone to page set up box is
checked in sheet and still will not print with grid lines

I have uniqure colored rows in my excell spreadsheet. Is there a formula to
count the total number of green rows, red rows, blue rows, etc?

I use sumproduct to sum columns of values after testing against 2 criteria.
At first it was working great, and then it stopped working once one cell
that I was testing against had a value in it. It's actually become quite
finicky. It'd work in some cases, but not in others.

On some worksheets my scroll bars are really tiny indicating that the
worksheet has data in it however there isn't any.  I have tried deleting
everything out of the blank cells however it tells me that there is
information all the way to BM10273, which there isn't.