![](/static/253f0d9b/assets/icons/icon-96x96.png)
I’m not sure about a formula but you can use Visual Basic to make a random number generator for a bunch of rolls and place those values in an array and then place the array in the appropriate cells.
I can’t tell you exactly how to do
This as I haven’t used excel or Visual Basic in a while and never actually linked them together myself. I don’t know if you can even do it for free as I think visual studio costs money, though that may show how long I’ve been away from that side.
I can say you can also do the same as what I describe above using Google Sheets and App Scripts in probably 20 lines of code. I am more fluent with those and I think it would be pretty easy even if you don’t know how to code.
Except you can’t. People can deactivate this for each contact in their address book really easily. You can even create your own for each person and have that override theirs on your own phone.