I’m a complete newbie to excel and am struggling to find a way to get a random row from B1 – B15 while excluding the rows with 0.

 It’s important to note that I need this formula to be able to work when the 0 and other values are in different positions, and when there are a different number of 0 values in the column, but the total amount of numbers will always be 15. Thanks so much for the consideration!

​I’m a complete newbie to excel and am struggling to find a way to get a random row from B1 – B15 while excluding the rows with 0. It’s important to note that I need this formula to be able to work when the 0 and other values are in different positions, and when there are a different number of 0 values in the column, but the total amount of numbers will always be 15. Thanks so much for the consideration!  Read More

​