Dear folks,
hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank.
Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the fact that the dealer can't be blank/must be text. And then I would like to retrieve the values from the stochastically selected row. Hopefully it makes sense what I would like to do.
<tbody>
</tbody>
hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank.
Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the fact that the dealer can't be blank/must be text. And then I would like to retrieve the values from the stochastically selected row. Hopefully it makes sense what I would like to do.
ID | Dealer | Pos | Type | |
122 | PS | 1000 | Buy | |
444 | DS | 1500 | Buy | |
321 | 1000 | Sell | ||
123 | TS | 1000 | Buy |
<tbody>
</tbody>