you can try eg. =INDIRECT("A"&RANDBETWEEN(1,10))
where your data is in A1: A10
or if you want randomize A1:E10 you can try: =INDIRECT(CHAR(RANDBETWEEN(65,69))&RANDBETWEEN(1,10))
you can try eg. =INDIRECT("A"&RANDBETWEEN(1,10))
where your data is in A1: A10
or if you want randomize A1:E10 you can try: =INDIRECT(CHAR(RANDBETWEEN(65,69))&RANDBETWEEN(1,10))
Last edited by sandy666; 04-24-2017 at 12:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks