Random Text

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I know we can randomally generate #s in excel VBA, but I
want to randomally select between text values.

Example if A1=Yes A2=No and A3=Maybe

I want a code that only looks at thses values and displays
one in cell B2. If I use the Randbetween formula function
I get the #Value error. because the formula is looking for
#'s

Is this possible?
Pete
 
Hardcoded:-

=CHOOSE(RANDBETWEEN(1,3),"Yes","No","Maybe")

Referenced:-

=CHOOSE(RANDBETWEEN(1,3),A1,B1,C1)
 
Back
Top