Hello,
Is there any built-in function to display a random cell in another cell? for example, i have data in cells A1 to B12, and would like that B13 display any number from that array.
If not, would you have any suggestion on how to create this?
Many thanks,
Try this,
=RANDBETWEEN(MIN(A1:B12),MAX(A1:B12)) - Press F9 to re-select
Last edited by oldchippy; 02-13-2007 at 10:39 AM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
I see!Originally Posted by oldchippy
But what if the values are in A1:B12 are... text?
Here's a link here that may help?
http://exceltips.vitalnews.com/Pages...dom_Names.html
Last edited by oldchippy; 02-13-2007 at 11:14 AM.
They are text unique:
A1 Apple
A2 Pear
A3 Banana
etc.
Sorry we posted at the same time - have a look at the link above
Excellent, this will do. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks