EXCEL PRO TIP: Random List Selection with OFFSET & RANDBETWEEN

[@wayneedmondson1065]

Hi Chris.. fun stuff! I did it in one cell using INDEX, as in: ="The " & INDEX(A$2:A$31,RANDBETWEEN(1,COUNTA($A$2:$A$31)))&" "&INDEX(B$2:B$31,RANDBETWEEN(1,COUNTA($A$2:$A$31))) Thanks for the video.. good fun.. and good learning! Thumbs up for Excel Maven!!

[@Luciano_mp]

Cool trick, thanks.

[@darrylmorgan]

Hi Chris!Just set this up for my Daughter 2 are making us laugh(THE SHAPELY MILKMEN and THE FRIGID AIRBAGS)Really cool bit of fun!Thank You :):):)

[@ExcelMaven]

Those are pretty solid! Love "The Shapely Milkmen" haha