Does Numbers support array formulas?
Does Numbers support array formulas?
MacBook Pro, OS X Yosemite (10.10.1)
Below is an example:
=IF(ISBLANK(Products!A2:A1000),"",Products!A2:A1000)
7 replies
Numbers does not support most Excel-style array formulas. However, there are often different ways to do the same thing, sometimes a little more cumbersome but in some cases actually more efficient (in both Numbers and Excel) than the original formula!
If you have a specific array formula you have in mind, could you post that?
SG
Unfortunately, each of 12 columns of the "Details" Page of this workbook are array formulas. Along with array formulas in the Summary page. The other 10 sheets are CSV tables of data that the Details and Summary Pages pull data from.
The initial reason for asking if Numbers 3.+ was a 64 bit-processing application was because Microsoft's Excel 2011 for Mac was only using 32-bits and my workbook start receiving an "exceeding resources" error. I misunderstood an answer to my problem and tried Microsoft 365, upgraded to a Microsoft Excel 2016 for Mac and still received the same error, very disappointing!
Ideally, I want Microsoft to support their Apple Users but I'm willing to give my money to Apple.
Currently, I am disecting the workbook into multiple spreadsheets to accomplish the reports that I want.
In general Excel 2016 should be able to handle anything you throw at it, even large datasets. Numbers is more suited to smaller datasets.
But it strikes me that, in both Excel 2016 and Numbers, you should be able to do what you are doing in a different way.
What, for example, are you doing with =IF(ISBLANK(Products!A2:A1000),"",Products!A2:A1000)?
Can you use a filter instead (which is powerful in both Excel and Numbers)?
SG
Hi SGIII!
Sorry for intruding on this discussion but I wondered if you would be able to provide some assistance. Having used excel for a number of years, I have finally made the switch to Mac & Numbers and have been very impressed so far... however there are a couple of formulas that I wanted help with, in order to get my head round how things work in Numbers and I'm hoping you might be able to give me a little pointer? They are:
{=SUM(IF('Monthly Figures'!$A$2:$A$908=B3,'Monthly Figures'!$D$2:$D$908,0))}
and
=COUNTIF(D3:D14,0)
Thank you in advance for any pointers you can give me.
Hi I33b3z,
Your second formula should work as-is in Numbers. It is not an array formula.
Could you start a new thread with your second formula, perhaps describing more what you are trying to accomplish with it?
SG
Here is another:
=IFERROR(INDEX(Map!A2:L1000,IFERROR(MATCH(G2:G1000,Map!C2:C1000,0),MATCH(G2:G100 0,Map!D2:D1000,0)),6),"")
Does Numbers support array formulas?