KarlsOne -

(1) If you have "a data set that works ok in another environment," why not
just use that environment?

(2) If you browse to microsoft.com and search for "excel two-factor anova
with replication" (without the quotes), you'll see Knowledge Base article

http://support.microsoft.com/kb/267281

which shows how the data needs to be arranged.

(3) If all else fails, use google.com, or refer to Ch. 13 of my book, Data
Analysis Using Microsoft Excel: Updated for Office XP.

All of the data analysis tools have been essentially unchanged in all
versions of Excel.

- Mike
http://www.mikemiddleton.com

"KarlsOne" wrote in message
...
I can use the One Way ANOVA fine. The TWO WAY either comes up with weird
results or does not accept the number of rows I enter.

If I have a table with 10 rows and 2 cols and I select that region using
the
ANOVA addin and enter 5 for rows, I get an error saying that I must have
equal number of rows.

I am using a data set that works ok in another environment.

This is with Excel 2003.