I am tring to calculate a city's Compound growth rate, but I keep
getting an error. the city has 233,149 as of 2004, and 242,820 in 2000.
My formula is =(D4/J4)^(1/(2004 -2000))-1
Thanks for any help.

Trying to simplify menu costing.  Can anyone help? I know this should be
simple but it is late...I appreciate the help!

I am using this formula:  =IF(B6>=A6:A390>=B5,SUMIF(F6:F390,
"*8in*",E6:E390))
to:
Sum values in the range E6 to E390  where 8in is found in the

In one of the columns I have text with email addresses I need seperated.
Amongst the text (i.e. "please note that Joe@Microsoft.com is no longer
employeed" - or - "Bob@Aol.com email is undeliverable")
Is there a formula that I can create to single out just the email address?  

I have a report that I need to pull data from each week.  The report has the
same four sales categories, just pulled by different filters.
For example:
Filter 1

How can I do this?
Old Cell                                                        New
Cell
12345.pleasehelp.405503.245                        pleasehelp.jpg

This should be pretty easy - I just can't seem to figure it out...
I have a list of people that attended a class each has a "Y" or "N".  
want % that attended the class.  So - the # attended divided by th
total number possible.  It should be a count of "Y"'s divided by count

Is there any way I can build a search tool in excel so that I ca
retrieve data from another sheet. i.e. the search tool is built i
sheet1 and it can filter and retrieve data from sheet2.
Also is there a way of setting excel so that regardless of what sheet

A1 B1
Col 1               Col2          Col3          Col 4
MS21044D9 AN365D918 AN365D918A MS20365D918
MS21044N02 F22NM-256 F22NM-02

This is the formula I am using:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44)
The conditional formatting I am using works on most cells but a coupl
are not working i.e.

Just this month I have encountered errors in excel when I run a subtotal on a
group of data and then run subtotals on subgroups within the data.  This just
happened this month on a report I have generated for two years.  I have to
get subtotal revenue for departments within a ...

I see it is possilbe to reference a worksheet tab name in a cell. Is it
possible to name a worksheet tab from a cell in that worksheet?  So if you
change the cell name it will also change the worksheet tab name.

I have been using excel to import data but when i try to sort columns some of
the information  changes how can i prevent the information from changing?

My Question is:  as I data imput down a column(of multiple columns) can it
highlight the whole row so that I can be sure it is the right cell?

I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?