Just wondering if anyone knows of a way to count blank cells on a sheet
then place the result in the cell it was counted from. Assumeing it has
a result itself.
In each cell I have have =IF(COUNTIF(A7:B7:C7:D7:E7:F7, "1")=1,"1","

I'm calculating a moving average, and I found this formula. In cel R14
this formula is set:
In cel R$1 there is the number 12,what are the days I want to calculate
the average. Cel G14 is the current closeprice of the stock. Can

Importing a .dbf file and not all the data is there.
I noticed that I have bottomed out at 65,536 rows
Thanks in advance!!

i'm  new to writing macros  for an  excel file.
i've a macro which will read the data from  worksheets and copies that data
and paste the copied data into new workbook sheets.
it is copying the data into new work sheet. whats my problem is my original

Hi!! I have a question ,hope someone give me some suggestions.
I am going to design two forms for "Time Slot Arrangement". One form is
filled by PM which is a summary of which engineer should go to which company
(our client) during this week. Another one will be sent to each ...

I am just learning about formulas and need some help.  I don't know if this
is possible or not.
I have two worksheet tables in excel The first is a report that list
employees &  the columns are: salaries, certification level, and # years

I have a cell 'A1' that references a cell in another (unsorted) column 'B'.
Every day I add a new column of info to the worksheet by inserting a
column. Column B then becomes Column C.
As a result of the insertion, cell A1 now references a cell in column C-

Hi, Can anyone help me on how i can calculate total hours between 2 date
and time. eg. Field A1 i have 12/25/2005 17:35 A2 i have 12/28/2005
17:00
and result will be in field A3

Need help with conditional fomatting.
What I need:
I got a worksheet with 950 rows and 5 columns. The first row contain
the headers. Columns A, B, D and E contains unique values. But the

How to start excel macro directly from a cmd

Do you know any function to calculate the angle? For exemple I would like to
calculate: 10d5'27"-9d52'28"=?
or 9d12'14"+2d19'20"=? (d=Degree, ' = Minute, " = Second)
Thanks in advance

Howdy All,
This is what I want to do:
I have a spreadsheet with 4 dates in columns I, J, K, and L starting in row
3.

,Hello Again
Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that  the value changes from 1 to a 2 and so on depending

I have a function,
   myfunction( )
which searchs for a string in a specific worksheet
   W

I have created a spreadsheet containing some macros.
I need to write a script of some sort that could run the spreadsheet
(allowing the macros to run) on a scheduled basis.
does anyone know how I can do this?