I have a simple table of 4 columns. I would like to randomly pick one of the 4 values into a result cell for each row. The curve ball is that any one of the columns may be blank. So I want to pick one of out of the non-blank columns. I can use RandomBetween(1,4) to get a column, but then would have to if() to see if blank, then RandomBetween(2,4) and so forth. Not only is it not very elegant but it adds a bias as column 4 gets 4 shots at being included, but column 1 only once. Any ideas on a better way to do this? - Pete