CSE Formulae

JC3 · Mar 6th, 2002, 11:59 AM

I'm new to Mr Excel but I've just tried out the CSE formulae (array formulae). Very impressed, but two questions:
1 - Is there a maximum size of array that Excel will handle?
2 - Is it possible to use an array across a range of worksheets?

Any help gratefully received.

Mark W. · Mar 6th, 2002, 12:10 PM

1. The physical limits of the worksheet, but some functions that handle arrays have their own limits (consult Help).
2. No.

[ This Message was edited by: Mark W. on 2002-03-06 11:11 ]

Dave Hawley · Mar 6th, 2002, 11:15 PM

Hi JC3

Be careful with array formulas they can be a trap that renders your Workbook virtually unusable! They slooowww down Excels re-calculation to a crawl if you have too many. Have a look at the Excel help of the "Database functions" these are far superior and are desinged to do what most unwary users use array formulas for.

They most certainly do have some contraints which I list here:
http://www.ozgrid.com/Excel/Arrays.htm

Mark W. · Mar 7th, 2002, 07:15 AM

JC3, array formulae are quite powerful and useful. I'm glad to see that you're taking the time to understand them.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 11:59 AM	#1
JC3 New Member Join Date: Mar 2002 Location: Chester, England Posts: 2	I'm new to Mr Excel but I've just tried out the CSE formulae (array formulae). Very impressed, but two questions: 1 - Is there a maximum size of array that Excel will handle? 2 - Is it possible to use an array across a range of worksheets? Any help gratefully received.

Mar 6th, 2002, 12:10 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	1. The physical limits of the worksheet, but some functions that handle arrays have their own limits (consult Help). 2. No. [ This Message was edited by: Mark W. on 2002-03-06 11:11 ]

Mar 6th, 2002, 11:15 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi JC3 Be careful with array formulas they can be a trap that renders your Workbook virtually unusable! They slooowww down Excels re-calculation to a crawl if you have too many. Have a look at the Excel help of the "Database functions" these are far superior and are desinged to do what most unwary users use array formulas for. They most certainly do have some contraints which I list here: http://www.ozgrid.com/Excel/Arrays.htm

Mar 7th, 2002, 07:15 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	JC3, array formulae are quite powerful and useful. I'm glad to see that you're taking the time to understand them.