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