Without seeing what you are working with I cannot say exactly.
=INT(1+RND()*x)
will generate a random number between 1 and x.
If you are using Excel 2007 (or prior version with analysis toolpack)
you can use
=RANDBETWEEN(1,x)
Use such random numbers to pick the lines you want to inspect.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.