I want to delete w worksheet.  Under edit, delete, 'delete sheet' is grayed
out. When I left click on the tab, it is grayed out. Under tools, protection,
'protect worksheet' is grayed out. Any suggestions?

Folks,
I wanted to know if there is any way that I can divide my Pivot Table data
by 1000.  In other words,
                   Data

Hi,
I've created a short custom function that returns TRUE or FALSE if one or
more cells within the specified range is colored red.  The function works
correctly, but if the interior color of one of the specified cells ever

I have a column which contains Vendor names in a spreadsheet with Vendor
data.  I created a formula that takes the first 3 char. of the Vendor Name,
then looks for a space then takes the next 3 char. after the space and
concatenates the 2 together to create a Vendor ID.  Here's ...

Can anyone tell me what formula to use to average something like this:
$50K - 20%
$40K - 20%
$30K - 60%

I'm using the MATCH formula and getting the number results I need. But, I
want to display/list which of my 7 records are duplicate.

=IF(MONTH(TODAY())>=MONTH($H$3),SUMIF(Jan!$G$16:$G$41,Summary!$B162,Jan!$X$16:$X$41),0)
This formula works fine in 2003. Shows result different than 0. I mean shows
correct results. In 2007 all results of formulas in the whole sheet are 0.

I calculate an average in cell G19 that includes the lastest 12 months
values.  Each month I need to update the formula to exclude the first of the
last 12 months and include the new month.  Currently I am doing this manually
each month.  Is there a way to automatically update ...

I have 2 workbooks.... in workbook #1 I have cells that have conditional
formating  to change fill color if the cell value is 1 through 4.  I want a
cell in workbook # 2 to change the cell fill color to match the other
workbook.  I have a formula in workbook # 2 which must not be ...

if i have figures in range A1 to A20 and B1 to B20 how do i easily calculate
them as percentages in C1 to C20 ?

In one particular worksheet, when I try to AutoSum a column of numbers, all
I get is the formula, i.e. "=SUM(A1:A1000)".  (If I highlight the column I
can see the sum at the bottom right hand corner).  
Can anyone suggest what I might have done wrong???

I am trying to compute the weighted average of a data set, conditional
on two criteria.  I know how to do it for one, but am struggling to
trigger the second.  Any help would be appreciated.  A simplified data
set is:

I am looking for help to setup a simple macro to navigate to a specific
range in excel. Specifically, I need the macro to move to a specific cell,
but move the cell to the top of the screen so everything is visible below the
selected cell.

MAX(VLOOKUP(A8,Sheet1!B2:E12,4,FALSE),VLOOKUP(A8,Sheet1!B2:E12,3,FALSE))
this works fine, but when I try to enter (ctl+shift+enter) the same formula
using the large function, I get an error
LARGE((VLOOKUP(A8,Sheet1!B2:E12,4,FALSE),VLOOKUP(A8,Sheet1!B2:E12,3,FALSE)),1)

I am trying to find the Average of the lower 10% of a column of data.  I
cannot figureo out how to do it without including the same values.  Thank you
in advance for any help you can provide