maximum number of rows!!1

E

ExHell

Board Regular

Joined

Aug 4, 2003

Messages

55

• Aug 4, 2003

• #2

Why that would be 65536

 

Upvote 0

C

ckmoied

Board Regular

Joined

Oct 13, 2002

Messages

154

• Aug 6, 2003

• #3

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

Is that possible.

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Aug 6, 2003

• #4

No.

 

Upvote 0

C

ckmoied

Board Regular

Joined

Oct 13, 2002

Messages

154

• Aug 6, 2003

• #5

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.

 

Upvote 0

eliW

Well-known Member

Joined

Mar 2, 2002

Messages

1,940

• Aug 6, 2003

• #6

ckmoied said:

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.

Click to expand...

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

Eli

 

Upvote 0