mercredi 22 novembre 2023

How to apply complicated random formula n-th time?

I have a big spreadsheet with a lot of data and formula, in F19 is a random value which is built from all these data and formula. I would like to get a sample of N=30 values that are given by this formula. Of course I could copy paste the number, refresh the sheet, recopy paste etc N times, but let's be smart here. Is there a way to do so?

I have tried using ARRAYFORMULA() but not sure how to use it to get a sample of N values from the F19 cell.




Aucun commentaire:

Enregistrer un commentaire