i have a qn regarding excel, does anyone here know how to randomly generate a character between "M","S" and "D" for each cell? Thanks you so much in advance
Try below formula-
=INDEX({"M","S","D"},,RANDBETWEEN(1,3))
1.4m articles
1.4m replys
5 comments
57.0k users