LinkBack URL
About LinkBacksOr do you just want to generate a list - or row - at random?
If you want to do a random set, place the numbers 1-4 in a column to
the left of your range of names, then try this:
=VLOOKUP(RANDBETWEEN(1,4),$B$1:$h$4,3,FALSE)
Or do you just want to generate a list - or row - at random?
If you want to do a random set, place the numbers 1-4 in a column to
the left of your range of names, then try this:
=VLOOKUP(RANDBETWEEN(1,4),$B$1:$h$4,3,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks