Excel Random Selection

Resolved · Medium Priority · Version 2007

Tue 11 Oct 2011, 13:41 Delegate Louise said...

Louise has attended:
Excel Advanced course

Excel Random Selection

What would be the easiest formula to use to randomly select data or rows of a spreadsheet, for example in an audit scenario?

Fri 14 Oct 2011, 11:26 Trainer Anthony said...

RE: Excel Random Selection

Hi Louise, thanks for your query. I think the link below should give you what you need:

http://www.ozgrid.com/Excel/excel-random-pick.htm

Hope this helps,

Anthony

Fri 21 Oct 2011: Automatically marked as resolved.

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips

Excel Random Selection

Excel Random Selection

RE: Excel Random Selection

Excel articles

Excel tip:

Display Functions on Worksheets