I have a lot of quarterly data for market size.  I am trying to find out how
I can calculate the average growth rate for this market.  For example, if I
know
- $10m was the initial market size

I have the below formulas that sum only months.  With the New Year 2006 upon
us, what do I need to add in order for them to look at month and year?
=SUMPRODUCT(--(MONTH(Overall!K8:K1003)=8))
=SUMPRODUCT(--(MONTH(Overall!K8:K1003)=MONTH(J1)),--(ISNUMBER(SEARCH(H6,Overall!N8 ...

I have the name of the month in cell A1 in each of 12 sheets.
From A5 onwards down the page I have the formula
=ROW()-4
which numbers each line.  Ideally I would like the numbers to include at

I am having problems with a vlookup
I need to find an estimate number from workbook 1 in workbook 2 and then in
an empty cell in workbook 1 bring up the selling price of the estimate that
was located in workbook 2.

I have a spreadsheet with three columns.
A: A date for every hour for the month (ie. 1/1/06 24 times)
B: The hour
C: A dollar amount

I need to convert a standard dollar amount (eg 157.62) to a 9-digit
number without decimals or rounding (eg 000015762).  The formulas I've
tried so far are:
For Each rw In ActiveSheet.UsedRange.Rows

Column of 1000 phone numbers. I've managed to eliminate area code using
replace with wildcards but can't seem to change the ? to  a dash. Everything
I try completely messes up the sheet and I have to undo. Even had to restore
once! Gah! Any help out there? :)

If cell A1 is 0, I'd like the text of A1 and B3 thru B10 to be gray.  I
know how to conditional format for the current cell but how can I also
format other cells based on the current cell's condition?
Thanks,

In Excel I made a product list containing 4 colomns and over 1000 rows. When
I print it I only use half the paper. I'd like to be able to put page 2 next
to page 1 on the same sheet of paper. Who can help?

Hi, thanks in advance for any help...
I have a series of 8 number codes (eg 12771497) that starts with one of the
numbers from 1 to 26, I would lile to replace for example 1 with A, 2 with B,
3 with C, 26 with Z etc

I'm trying to take a number shown in one cell and show it in text in another
cell for example $300.50 is Three hundred dollars and fifty cents.

This may be a shot in the dark and will be a long formula, but here it goes:
I have multiple columns that I want to condense to one.  Therefore, I want
column B to show current status of a work order based on the following:
If column V is blank, column B shows “Open”.

How do I insert the Copyright symbol in the footer? Many thanks.

I was using the following formula when filtering a sheet of data:
=OR(B2=1,AND(OR(B2=2,B2=3),L2<>0,K2=0,I2>=ayearago))
It filters all rows with 1 in column B and any other rows with 2 or 3 in
column B that meet the criteria L2<>0,K2=0,I2>=ayearago (where ayearago is a

I am trying to do a project budget and I'm adding 2 cells that are not next
to each other in the spreadsheet. I do the automatic sum calculation with
this formula- Sum(R122,R183). A non value appears.
I did the long version of picking it through the Insert Function box. The