Questions about array-formulas
Read more about array-formulas
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to populate rows based on the number required in google sheet?
Hi all,
I want to use a formula to duplicate the department name based on the number of employee in the department. For example. there are 2 employee in Finance department, so the formula will duplic...
weizer
Votes: 0
Answers: 2
how to fill a complete column with arrayformula and containing Vlookup of base on a single cell criterion
I need this exact formula into V1:V column
=VLOOKUP('Target Sheet'!$G$1,IMPORTRANGE("MYLIST","FileLInktoAgent!$A$2:$C$45"),2,0)
That formula works perfectly for 1 row, I want all ...
Marc Robillard
Votes: 0
Answers: 1
Running SUM with ARRAYFORMULA
I have a list of values per day and I want, for each day, to sum the last 7 days using an array formula.
Basically, I want to use this formula
=SUM(A1:A7) inside an ARRAYFORMULA but I can't get it to ...
Tom
Votes: 0
Answers: 2
Need some help in understanding this Google Sheets arrayformula function
The function is:
=arrayformula( (NORMINV(RANDarray(1,4000),$K3,$L3) * AVERAGE($G3,1)) * $J3 )
My understanding is that this creates a list of 4000 random values and for each random value, it passes th...
chomprrr
Votes: 0
Answers: 1