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.