Jun 21 2022 09:02 AM
Hi, I am trying to develop a cheat sheet for multiplications for estimating. Usually if you have a vertical column with numbers and a horizontal row with numbers you can drag the formula across or down with one answer. Not happening on my spreadsheet
Jun 21 2022 09:14 AM - edited Jun 21 2022 09:16 AM
If you have access to dynamic arrays you might try:
[A2:A11 = 1 to 10 B1:K1 = 1 to 10]
=A2:A11*B1:K1
Another approach:
=MMULT(A2:A11,B1:K1)
Jun 21 2022 09:52 AM