I have a for a formula in a macro:
ActiveCell.FormulaR1C1 = _
       "=MID(R[-11]C,FIND("","",R[-11]C,1)+2,10) & "" "" &
MID(R[-11]C,FIND(""D_"",R[-11]C,1)+2,FIND("","",R[-11]C,1)-FIND(""D_"",R[-11]C,1)-2)"

In Lotus 1-2-3, you are no longer tied to a criteria range.  You can embed a
formula in the criteria field.  For example, if I have a database named
Calendar with columns titled:
Number   Name   Weeks

I need to add up the total number of cells in a column that contain entries.  
THe entries are dates i..e,
Column A
March 3, 2008

I have a pivot table of sales data.  I need to have a calculated field that
gives me my sales mix.  In an excel cell the formula would be =(2007%of
Revenue)*(total2008Sales$)
I have fields in the current PT that give me the % of revenue, and the sales

I have a range of cells that we merged and then unlocked.  When we protect
the sheet and say the user can only go to the unloced cells.  We can tab thru
until we get to the cell that created from a group of cells merged.  it will
then tab to the next cell and just keep going back ...

I've been using the concatenate function in Excel to make text strings out of
multiple cells, and I'm trying to do so for cells that include dates and
times. When I concatenate these cells and they are converted to text, I get
the general number format for the dates and times ...

when the question of how to get a template to number each new workbook that's
opened, regular reference to the website:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html is made, but i copied
the text, pasted it in my workbook's visual basic editor (opened by right

I have dates & times which I need to enter (which is the easy part).  
However, I need to use the difference (in hours) to calculate the cost
incurred when the hours fall between 0600 -1800 (day cost) and 1800-0600
(night cost).  If the hours fall between day cost hours, then I ...

I have what I would think is a fairly simple function that I cannot get for
the life of me, if I am looking to write a formula on one spreadsheet using
the intersection of 2 values (actual words in this case) can I write a
formula that will search vertically for one of the words ...

I have to create a staff roster each month for volunteers in different
locations around the country.  At the moment I had each persons name manually
to the time cell relating to the hours they can work, eg, Mon 8:00 - 12:00,
12:00 - 16:00, 16:00 - 20:00 etc.  Is there an easier ...

In Row 1 of my spreadsheet are dates in MMM-YY format.  I Row 2 are different
values.  What I want to do is maintain an average, by year, in another cell
on another worksheet that changes every time a new month of data is added.

initially when the pivot table is created all the fileds show in the field
list.  After amendments the hours field disappears from the field list
although it is still on the the pivot table.
Any ideas why thisi s happening

I have the formula =SUMIF(K14:K267,E2,V14:V267) but want the number to
only reflect when I filter by data in column H. Any ideas?

I need to create a macro that copies two adjacent cells A148 & B148 (same
cells each time but with a different value each time) and pastes them into
another column but moving down one row each time. The object is to retain the
previous values ultimately resulting in a column of ...

I have a Workbook with 3 worksheets
Sheet1 called quote form
Sheet2 called Help
Sheet3 called Data