I'm struggling through doing some binary math on excel.  Ugh.  You'd think
Excel is written by programmers, so they would see the value of having
some programmer-friendly bitwise math and binary, octal and hex formatting
stuff in there, if for no other reason than they could use it ...

I am looking for an example of using a custom validation rule.
If I have some numbers in cells A1:A8 and set up a custom validation rule in
cell A9 that says in the formula box =SUM(A1:A8) then I can enter that
formula in that sell but also could enter =SUM(A1:A5) or even the number ...

how do iopen aspreadsheet  sent via email windows need to know what programme
created it .i dont understand

Does anyone know how to have a numbered list in only 1 cell?  My coworker
has seen this done before.

I have a question about multiple conditional calculation. Here is my
question.
A    B    C   D    E             F
A1   B1   C1  D1   =Max(A1:D1)

We know how to repeat rows for printing, but want to be able to view, or
keep them stationary, the top 2 rows of the sheet while scrolling or paging
down.
Can this be done?

I have a lookup table with dates as the first column (in order).  Is
there any way to use an array in a vlookup equation to sum up data that
occurs on consecutive dates?  I thought something like the following
would work: {=sum(vlookup(a1:c1,Dataset,5,False))} where a1:c1 refer to

I am using MS Office 2000 on a pc running Windows 2000.  I have just
recently encountered a problem when switching between sheets in a workbook.
When I click to select a different worksheet, a rectangular icon, (kind of
like a sheet of paper), with a "+" sign by it, appears in place ...

A sheets cell have a named.
Exaplme: Sheet1!Records=[Sheet1!B1]
I don't want use Sheet1.Range("B1") in VBA,
because the cell can moving sometime.

Hi all, someone has sent me a .qpw file and I am unable to open it. From the
little research I did it appears this is a Quattro Pro Windows file and
there is a way to open it in Excel 2003? But I am unable to do this. When I
select open in Excel 2003 the only option I get is ...

I had to make a spreadsheet for a sales budget for my accounting course and
my professor wanted us to show him the spreadsheet in a formula form ...such
as ... =d4*c5 something like that....now the problem is that i dont kno what
button to push to make the spreadsheet turn into ...

Hope you can help.  I have a Macro in an excel file that looks for and
opens another named excel file based on some variables.  For example a
new spreadsheet is opened today called 100305 (based on the date), the
macro will then look for a file from the previous week (030305), open

Howdy All,
Here is the situation. I have a workbook with separate worksheets for major
accounts. These worksheets have various account data on them.
Here is what I would like to do. I want to create a summary worksheet that

I am using xp- I can"t email a excel file?

I am new to excel and have a question regarding cells being filled with data
automatically
If I want to have a cell that contains a product, how do i get the cell next
to it to fill in the price automatically - I guess i am going to have to have