maximum number of rows!!1

[ckmoied]

what is the maximum possible number of rows in excel 2000.

 

[ExHell]

Why that would be 65536

 

[ckmoied]

what if I need more rows in excel. suppose I need over 150,000

Is that possible.

 

[Andrew Poulsom]

No.

 

[ckmoied]

so whats the solution in that case.

I have about 5 years data and each year has about 35,000 records in each row.

I want to do statistical analysis by combining all 5 years.

How should i do that.

 

[eliW]

so whats the solution in that case.

I have about 5 years data and each year has about 35,000 records in each row.

I want to do statistical analysis by combining all 5 years.

How should i do that.

Hi,
Copy your other years to different columns in the same worksheet.

Eli