I have a new computer and I am trying to save spread sheets from the a drive
to the spread sheets and they didn't work right.  How do I get rid of the
ones I cannot open, so I can download them again?

I have to save 400 copies of the same worksheet in different names.
Any idea's of how i can do this as easy as possible?

We have 520 inputs...20 categories x 26 participants
For the Standard Deviation do we use the average of the 20 categories or the
520 inputs?  We used stdevp on the 520 and got  1.1  When we used the stdevp
on the averages of the 20 categories we got .3

          Is it a way to get  its k-value from percentile and array. Thanks.
PeterK

I'm using a shared, protected workbook, with AutoFilter enabled, that
allows users to make edits in certain columns. When users edit the
workbook and save it, their AutoFilter settings are being saved as
well, even when the Filter settings box is unchecked in the Share

Could anybody help to get the code that can copy the value of cell to
clipboard in double click?
I tried this but it copies the cell not the value of cell:
Private Sub Worksheet_BeforeDoubleClick(ByVal _

question for you..
i want to use a vlookup like feature to get data from more than one
row.
so lets say column A has my lookup value..  i need it to find the row

Afternoon
Something very odd is happening. I have a file containing population data by
region (columns), split into 4 year age range increments (rows). In another
file I am generating two rows, one for children and another for adults, with

If all the cells within the given range are blank, the following
formula evaluates to "#VALUE!"
=IF(AND(ISBLANK(H42:CS42)),"",CHAR(MAXA(Sheet1!32:32)))
I'd be grateful if someone can tell me either how to correctly rewrite

I have date 2 different places i my workbook. I would like to use the
fraktile function on these data - how do I do??
=Fraktile(ventor;k)
if I type =Fraktile(AND(a2:a7;b2;b7);0,75) I dont get the right result.

sheet1 ( 4 columns. First 2 begin / end dates)
1/1   3/3   teamA    121
4/3   6/6   teamA    322
7/6   8/8   teamA    455

I need some help trying to calculate a date.  
I have a month end date of 1st April 07.  I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.  
I have a formula which calculates the date that these items are due which is

I want to be able to put text on several lines in one individual cell in
excel using the the carriage return without wrapping the text. I also want to
put spaces at the end of the sentence which stay there when you adjust the
width.

How to generate matrix of nonrepeated random numbers in Exel?

I want to insert a picture in an unlocked cell of a protected sheet.  How do
I do that?