i have three measures:
Met all criteria - 63
One criteria  missed - 30
Two or more criteria missed - 7

Hey hey hey!
Frankie's back!
What's going on with the rest of you?
-Cheers

Say I have a column that I want to work on with a formula. I want to take
each value from the column, apply the formula to it, and total the result
in a footer cell for the column. Example: subtract 3 and multiply by 1/2
1

Is this possible, & if so, could you point out where?
I can't find it.
Thanks
Dave F.

I have a worksheet that has a table of data.
The table spans cells B2 - Q72
I would like to place the same table of data underneath it but sorted
by one of the colums in Ascending Order, then the same again

create a macro to calculate date of birth

Some strange behaviour to report.
My excel spreadsheet has a list of dates that have suddenly been
converted to Text format i.e. 02/09/04 is showing up as 2/09/04.
I can remedy this by formatting the cell to dd/mm/yy but it isn't until

I have a Excel WorkBook 'WrkBook1' containing macros to read values from
Excel workbooks 'WrkBook2', 'WrkBook3' and so on. But when I read the
values, the Excel Workbooks 'WrkBook2', 'WrkBook3' and others will open and
close visually during the reading.

I accidentally saved a sort that I did on a single column, can I undo it
somehow?  Is there a way to trick Excel into giving me back what I had before?
Thank you,
Katherine

   The user selects anywhere in excel Say B:1 to B:5.
   Then they execute the macro I have written to copy this information to a
given area in another work book. This works fine.
   What I would then like to happen is the initial selection area to move 1

I'm trying to create a macro from scratch, and when I select Tools,
macro, and go to the dialog box, the "Create" button is grayed out.
What would prevent me from being able to access this feature? I checked
to make sure the worksheet isn't hidden (I know this can prevent

Dave, thanks for your response.
I copied one of the graphs that was affected to a new worksheet, and
yes the label did print. So from that test i can assume it is not a
problem with the printer drivers.

I have a spreadsheet with almost 10,000 rows that I am going to do a lot of
sorts and subtotals on.  I want to be able to start near the bottom row but
not the absolute bottom one and and select up to almost the top row but not
the absolute top.  Aside from holding down the left ...

i would like to enter the array formula for frequency in cells B34:F34
(ROW 34) as follows:
{=FREQUENCY(B5:Q5,B32:F32)}
however, i get a bunch of zeros. if, however, i enter the formula in a

   I have recorded the following Macro ....
Sub Paste_TSR()
'
' Paste_TSR Macro