Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Low Priority · Version 2010

Reply Tue 8 Nov 2011, 12:59Delegate Galina said...

Galina has attended:
Excel Intermediate course

Formulas

Is there a formula in XL where you can select a random value from a list of text values?

For upcoming training course dates see: Pricing & availability

Reply Fri 11 Nov 2011, 10:45Trainer Andrew said...

RE: formulas

Hi Galina

Thank you for a question. How about

=RANDBETWEEN(1,50)

Where 1 is the starting figure and 50 is the maximum - change the max to suit your requirements.

This could then be combined with the Index function:

=index(array,randbetween(1,10))

where array is a column of 10 cells that contain the text items
to be selected.

If you press F9 this will force Excel to refresh its random number and you will see a different item selected from your list.

I hope this helps - let me know how you get on.

Kind regards,
Andrew

Excel articles

· What Is A Sparkline And How Do They Work?
· Excel Brings You The Tools To Spice Up Your Spreadsheets
· How To Use The Subtotal Function In Excel
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Do You Need To Run Excel 2007 In Compatibility Mode?

Please browse our web site to find out more about
excel.training.course.london and other Microsoft training courses.

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips