Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Random Selection
Louise has attended:
Excel Advanced course
What would be the easiest formula to use to randomly select data or rows of a spreadsheet, for example in an audit scenario?
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.
To create an autonumber field, can use the Offset() function.
In cell A1, enter the number 1.
Then in cell A2, enter this formula:
=OFFSET(A2,-1,0)+1
Then copy the formula from cell A2, down as far as you need.
See also: Autonumber in Excel forum post.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
