Hi, I have the following formula working out a random Yes / No based on some probability.
In B23 I have the following code (it sits in a table)
=IF(A23="","",INDEX($A$2:$A$3,COUNTIF($C$2:$C$3,"<="&RAND())+1))
However as more data gets added below A23, it recalculates.
What I'm looking for...