How to Use Array Formula in Google Sheets: Use Cases & Examples

[@lafamillecarrington]

I always use formatting to show which cells have arrayformulas and their contents. Same for query.
I also like to have the arrayformula in the header, using ={"Header";arrayformula()}

[@nuristiazizah2932]

Hi thank you for the video, it was great! Can we have the file to practice? Thanks before!

[@coefficientio]

Hi Nuristi - you can make a copy of the file here:
docs.google.com/spreadsheets/d/1PT8pa9xGBNxVxkSOKeLaCJ4nKMEeJVqLS0G1UR7Tf-s/edit?usp=sharing

[@evangelosanastasiou8384]

You don't have permissions to access that spreadsheet.
I am the same owner of bothe files..
I have anyone with the link and editor setting for the both files..
it keeps appearing the same message..

[@coefficientio]

We hope you were able to figure this out, Evan!