Help!
 If a person require to run 36000 items per hour. How do I
show in excel converting 36000 to  one hour using time format.
I tried 36000/60/60 = 0:00:00  did not work.

Please help. How can I find nonblank cell in group of cells (one row)
and than get value from cell in that column and specified row and
return in another cell.
And repeat that in many (about 300 rows)?

Hi.  I have a Pivot Table that uses three fields from a source table:
Job Name
Points Done
Points Remaining

in macro have code:
01=Range("a3").value
What code will display value captured in o1?
cell a3 can contained "Product:" or number 4

Hi,  I am new to pivot table.  I created a pivot table with the
"customer ID" as my row field, and "date of the month" as my column
field.  Then I selected two fields as my data.  One field is the
category of the things the customer bought and the other field is the

An engineer in the heating company that my company uses liked a job
scheduling spreadsheet that I had made at work in Excel 2002.  I e-mailed it
to myself at home where I have XL97, customised it for his use and e-mailed
it to him but I had forgotten that I had signed the macros ...

Could i get the SQA results 0f 2006.Thanks.

I am currently working on a project that involves several hidden
workbooks to be open.  I have a script that switches these files out
based on a selection.  The files have to be closed in order for the
switch to take place since it is copying a background file to become

I need to add the number of training hours for the past year.  This range
will change as the months go by.  I've tried a number of different formulas
including combinations of formulas, and so far, nothing's worked.  I know
this is available, I'm just not remembering how to do it ...

ok ive been trying to make excel do this, but im stumped...
basically i have a sheet that has
group    tag   description     part #
#1          1       misc            ABCD123ABC

When working on excell, how can I override this "Too Many Cell Formats"
comment?

Wht is it that Excel does not accept a zero as the first number of a 5 digit
zip code? How do you get Excel to accept it?

I'm trying to solve a rather easy mixed integer linear program using the
Excel Solver and have an unusual constraint problem.
I have have 17 decision variables and I need to add the constraint where
each of the variables have a unique integer value. However, I cannot

Evening Chuck
I tried your suggestion
=IF(ISNA(VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE)),"Invalid
Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FALSE),VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE))

I have a list of invoice dates where the day is first and the month is
second, and the year is third.  I need to convert to the US format of month
first, day second and year third.  Any suggestions are most appreciated.  
Thanks.