Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Is there a formula for Numbers that when entered in one cell will fill a omplete table?

In the App Store (Mac) window, if one scrolls down a bit, there is an interesting article on Excel's "Magic Formulas". It shows how to use Excel's "dynamic array" capability to enter a single formula that results in a full table being filled. The specific formula is interesting but doesn't work in Numbers. I wondered if there is an equivalent Numbers' formula that would.


First, I'm not sure I understand what "dynamic array" means — maybe ranges that define or identify a block of cells? Second, it's entirely possible that Numbers doesn't support this particular functionality.


Is there an equivalent formula for Numbers?


Example: With numbers in cells B1 through J1 and in A2 through A15, "=B1:J1*A2:A15" will put the results of multiplying B1*A2, B1*A3, B1*A4 … J1*A13, J1*A14, J1*A15 in the appropriate cells. These are the 2 tables from Excel:


BLANK TABLE WITH FORMULA

RESULT:

MacBook Pro (2017 – 2020)

Posted on Aug 7, 2024 8:54 AM

Reply
3 replies

Is there a formula for Numbers that when entered in one cell will fill a omplete table?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.