I have +rand() in cell A1. I want to find a way to change the number in cell A1 to a new random number, when a counter reaches 10. The counter should increase by one each time I add data in any cell between cell A2 to A11.

Anyone have any idea how to do it without using VBA?