1

In the attached example file where in sheets “Peter”, “John”, “Albert” I inserted the following formula in B4,C4 (October), B42,C42 (November)

=transpose(query({Planning!A3:DT3};"Select "&ArrayFormula(join(", ";text(query(transpose({column(Planning!BM3:DT3);mod(column(Planning!BM3:DT3)-column(Planning!BM3);2)});"Select Col1 where Col2=0");"Col0")))))

I should insert formula in 35 sheets for six mounth planning. How to loop this formula in a function?

https://docs.google.com/spreadsheets/d/1P6Nu90yQQWCdi4Bq14gVXpdZh_TMFsSxxtGjbrmZizU/edit?usp=sharing

Improve this question
3
  • 1
    sheet isn't shared for access Commented Oct 25, 2021 at 13:01
  • Questions should be self contained. While external links are welcome(note: Google sheets exposes your email address), consider adding a table or screenshots or csv text(like this by exporting as csv) to show your data structure. Commented Oct 25, 2021 at 13:19
  • docs.google.com/spreadsheets/d/… a new link for MattKing Commented Oct 26, 2021 at 12:54
Related questions
2
Loop through columns looping through rows
0
Looping over row and copy them on the next sheet
0
Transpose columns into rows through loop
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.