Bob, I am studying your wonderful article on sumproduct.  I have this:
           A              B
1        Make        Month
2        Ford          June

I have a problem. I am entering a list of items we have in inventory, the
serial numbers are a combination of numbers and letters. a few have numbers
to start and end in E77.
an example is 3934576E28

Hi, I am using the IsError function nested in an If statement to try and get
the macro to skip over some steps if the search comes up empty.  I pass the
search variable (Acct) from a function based on the number of the loop
(counter).  Works fine if the search has a positive ...

With my poor vision I have a hard time seeing the structure in a formula I am
writing or modifying. The built-in tools are useful, but I would like an
option to toggle the formula from this:
=IF($B26="","",ROUNDUP(INDEX(Refs!I:I,MATCH($M26,Refs!H:H,0))*K26,0))

I need a formula that will total all the payroll, overtime and training hours
for B and C in the below example:
         A                B          C
1     payroll            15        8

How do I automatically get the font color to change if I have a date that is
over 18 months old.....like I have February 1 2006 I want that to change to
Red because it is over 18 months old.
Thanks

i just wanted to no by entering this into a cell "C3", the following
=IF(B3<=0,"B3 must be integer greater than zero",(A3^B3)/FACT(B3))
FACT (B3) will give you the Factorial of the value in B3.
is this a VBA programme or do i need to write in visual basic for it

I have a user who keeps seeing the ^ symbol in his Excel cells and he wants
to know what it means.
Thanks,
Steve

is there any formula that put the sheet name in the same workbook any column
or row

I have many files that contains cells in which sentences were split in
multiple contiguous cells. As an example, I have "How are" in A1, "you doing"
in A2 and "today?" in A3. I need to merge these 3 cells by keeping the
content of A1, A2 and A3 into A1. There could be a variable ...

I need to copy cells from one worksheet to
another [same workbook], based on two conditions. The conditions are simple,
e.g. ISBLANK($A30) and $C30="OPEN", etc. The original column has 200 entries.
Only 50 of them may be copied in consecutive cells in a column on the new

I am trying to compare data between 2 different worksheets.  I have them both
open (side by side).  Is there any way I can set it up so that when I scroll
in one active window, the other open windows will scroll in sync?

I made some changes to a spread sheet that were wrong and then saved the file
and would like to be able to go back to the previous version of this file.  
Is that possible?

can i print part of a work sheet with grid line and part without grids line

I am struggling with getting a return value of 1 or 0, or true or false from
a cell that conatins text.
I have text in one cell, what i need is to look at that cell, detect either
text or nothing and return the value of true/false, or 0 or 1.