I would like to have a column with daily averages.
Per example, In C25 i have "x" and in C27 i have 30. So, in both D26 and
D27, i want 30/2. Because i had 30 in two days interval.
     B      C     D

I'm hoping this is possible..
What I have is a name column like this:
ANTHONY D DE ROSE          
EDUARDA J DE SOSA          

Can someone please clarify the difference between the two arrays you need for
a FREQUENCY function?
Thanks

I need to know how to protect a range of cell/s in a workbook

I need to convert a date and time into a specific letter. I have the date is
in one column and the time is in another, and need a letter output in a third
column. I need the conversion to look something like this:
Every Sunday,Monday,Tuesday from 07:00 to 19:00= A

I have some xl files that have many macros in them.  For
example 20 xl files with 10 macros in each file.
I have the following macro in it's own xl file that I use
to delete the macros in the other files before I save the

I have a spreadsheet that I am creating a pivot table to condense down some
information to make it easier to read. The spread sheet is an inventory and
has more columns than are needed and it does not show a total for each item.
The pivot table seems like what I need to show this ...

I want to protect the Page field in a pivot table and have tried leaving the
Page field cells status as locked and unlocking the other fields within the
pivot table and then protecting the sheet, but it seems to protect the entire
pivot table.

I hade worked on my web site. Then i turned comp of and came back and i came
here and i cant find where to keep editing my site. and im getting kinda mad

After my machine has been running for awhile, when I open Excel 2007, no
workbook is visible. I just see the blue background. Yet the default 3-page
workbook is there, I can see it and the sheets listed in the VBA IDE. When I
open one of my own workbooks, it creates a new window ...

I have to following inventory data:
Pool Part # Final Discrepancies Actions
FG11    286692-001    -1
FG13    286692-001     1       Move 1 to FG11

I am posting again, hoping someone can help...
I have a spreadsheet that does not have a continuous line of data (poor
spreadsheet planning).  What I need is a macro that will look in column M for
a "1" and then move over to column T and sum the numbers below, then look for

Please inform me how to assign a single desired key, when pressed to input
long data.
For eg:
Assign key "A" to input 377.88998774, instead of typing in the cells several

Hello. I want to make a count concerning two columns A and B.
The column A has text such as TT and TP the column B has numbers.
example
A            B

The worksheet is not protected.  "Sort" is faded.  I created the worksheet
and never protected it at all.  All cells are unlocked.  Can anyone help