• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel, need more columns

MrsGoof

Super poster
Joined
Jul 15, 2005
Messages
2,032
Likes received
55
Thanks received
51
Location
Lundun
I'm using Excel to do some analysis on data. Unfortunately I've run out of columns, they only goes upto 'IV'.

Can I change this anywhere, or will I have to resort to multiple workbooks.

TIA

MG
 
MrsGoof said:
I'm using Excel to do some analysis on data. Unfortunately I've run out of columns, they only goes upto 'IV'.

Can I change this anywhere, or will I have to resort to multiple workbooks.

TIA

MG

For serious data analysis you probably want SPSS or
Maple as Excel is a quite limited (as you're finding out)
 
The maximum number of columns in Excel is 256.

Lots of people want to do a spreadsheet with day of the year along the top. No chance.

Has been this way since year dot, even though all the competitors have supported 1000's of columns years ago.

Just shows you that you don't have to write good software to make money, just stick a Microsoft badge on it. :D
 
maybe I'll try and put OpenOffice on the client PC
 
What are you doing that means you need more than 256 columns?

Should it be in a database instead?
 
Apparently the next version of Excel (2007) will have 16000 columns and 1 million rows....if you can wait....
 
TonyEnglish said:
What are you doing that means you need more than 256 columns?

Should it be in a database instead?
It's just a simple piece of analysis on some data extracted from a Mainframe DB (NOT SQL based). I cant perform this manipulation using tools available, I could write a program but this would be quite complex, take several days to write and several months to be allowed to run on the production system.

I've got the results I want with just over a days effort, which aint too bad.

I'm there now, thanks all


MG
 
Lockhouse said:
Apparently the next version of Excel (2007) will have 16000 columns and 1 million rows....if you can wait....

It would be 2220 befor the customer gets to having that
 
You can always use multiple worksheets in the same workbook.

I can't remember what the limit is for worksheets in a workbook, but you can definately have over 100. So 100x256 gives you potentially 25600 distinct columns!?

VBA can be used to link the information, if using spreedsheet techniques aren't enough for your analysis.


Edited to say: I was too late posting a reply and you have the solution!!!!
 

Advertisers

Back
Top