This is what I have in my Google Sheets.
I want to pick just one row from this Sheet but with the
I want to Pick
Random Data from a Row but only with
No in the
I feel this can be done if the data returned with
No then loop it again to pick another row. But this will increase the limit of Read/Write.
More than that.
Random Data 5 is picked I want to updated Marked from
So that the same row won’t picked again.
Any ideas on how can this be done?