Can I use Excel to perform the statistical operation commonly known as
cross-tabulation on my opinion survey data?  Thanks for your help.

I need a formula that can help me do the following:
I have a pricing grid in the following format,
     A         B       C         D       E
1             500    1000   2000   2500

The following is a formula I am using that totals a range meeting a
single criteria.
=SUMIF(D2:D254,D507,E2:E254)
However, I now want to give an additional condition; that is

I just want to make sure, before I sink too many more hours into the
UDF Im writing right now, that I have an accurate understanding of
Pivottables.
Am I correct in thinking that a Pivottable effectively caches data by

I have an incompatibility between Excel 2000 and 2003 and I want to
understand why. I have the formula
  =TEXT(12, "N00")
In Excel 2000 I get

How do I find the MIN and MAX of data based on 3 different conditions?  

On our timesheets we must enter quarter hours as .15, .30, .45.  Is there a
way to
enter these decimals but have excel calculate them as .25, .50, .75.
Thanks,

How do I create a formula that would not allow a numeric value to be place in
a cell that is less than a value in another cell?  Using Excel 2003 w/SP2.

I am entering data in sets of three cells in each column on a spreadsheet.
Can I set up an auto return so that when I hit "enter" on the third cell, it
will automatically go to the first cell in the next column? (Bascially set up
a pattern such as - <enter>=go down one cell, ...

I would like to make a macro that takes a chart object as an input and
outputs a chart object that is the same format as the input chart in
every way except for the data inside of it.  So each series in the
chart will be the same format and the format of the file and the legend

I want to get a 1 if true, a 0 if false...
What I'm looking at is:
if the total of 3 cells=0 AND the average of 5 other cells >=30, then 1,
else 0

I have column A with over 500 account numbers.  What is the formula that will
allow me to see which of those accounts are listed more than once.

this is irritating. I don't think i'm doing anything differently, but I am
obviously doing something wrong. Plus I thought I saw this in a thread
recently and can't seem it find it. so sorry for a repeat question!

I'm beating my head against the wall here.
I have a sheet.  In column B is a description like 'CPU TYPE' column C has
the Value 'Intel P4 3.0'.
There are thousands of values in this sheet.  I was hoping to add a second

I'm trying to write a new purchase agreements templete in excel.  The top 15
rows of the templete is basically text with a bunch of merged cells and then
some single cells that I use to fill in the blanks; ie, date, name, address.
The remainder of the rows I use to list all the ...