I'm trying to count the amount of times a txt string appears associated
with a date on a different worksheet between two separately entered
dates on the sheet were the calculation is being performed. Im using
this formula but it only returns the 'value if false' even-though the

i have a workbook that has 53 worksheets
52 of the worksheets are name week numbers ie week 1 , week 2 , week
3..................week 52
i have on worksheet called graph

I want to create a chart with stacked bar charts, by week.  One stacked bar
chart for open risks and issues and the other for closed risks and issues.  I
also want to plot a line graph for outstanding items (which I think I can
do).  Does anyone know how I achieve this result.  ...

One of the most painful things in Excel (2003) is that you have to set up
the printing options (margins, header, footer, scale etc.) for all sheets in
a workbook individually.  Is there a hidden option somewhere that says
"apply print options to all sheets in workbook"?

How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance

I frequently enter text into cells.  Sometimes the text is entered in
lower case letters.  I want the 1st letter to be capitalized
regardless of my entry.  Are there any suggestions?  Thanks in
advance.

I have attempted to install this macro code many times now. I always get an
error that tells me that "The number in this cell is formatted as text or
preceded with an apostrophe." If I convert to number it just becomes that
number and not a sequential one on subsequent reopening.

I need a clustered 3d column chart that compares 2008 to 2009 and I
can’t get the axes set up right. I need the grouped series across the
bottom to be the Minority groups, with each year on a different depth
axis (row of grouped columns). Can that be done in Excel?

I have an array formula which finds a negative average correctly but not a
positive average for a small column of numbers
For example I have a small column containing positive and negative numbers
- formatted as percentages. Column A1:A20

Using Excel 2007, I am trying to find a formula that will enable me to count
unique values in a range.
For instance:
CAB1

Pls i want to get some detail in file -  
i have a pricing code      example code -  wo/st-kdi  i want to giv
this to short cut key 1M
code -  wo/st-kde      i want to give this to short cut 2  

I am sent an xls that includes a worksheet that is a pivot table.
There are a couple combo boxes in the first row (e.g., Date, Year)
that if I were able to connect to the external data source would allow
requerying of the pivot table.

Does ribbon/UI hiding using
Sub HideRibbon()
   Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

Is there a way to reset the command button counter.
I just added 1 command button and the number is 6120.
I do not have any command buttons in this workbook at all.