Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: MS Excel Functions Select a random sample of rows in Excel Tutorial

Use the excel random number generator to get random sample data from a spreadsheet.

Tutorial Details:

MS Excel Functions Select a random sample of rows in Excel Tutorial

There are several approaches to this. Here is one way to accomplish this. Let's say that your 50 numbers are in cells A2:A51.

1.Highlight cells B2:B51

2.Enter the formula =RAND() and hit Ctrl+Enter. This will enter the formula in all 50 cells at once

3.Copy B2:B51 with Ctrl+c

4.PasteSpecial the formulas into values by using Edit - PasteSpecial - Values - OK

You have now assigned a random number to each row. You could sort by column B and take the top 5, the bottom 5, whichever you prefer. If for some reason you can not sort the data, you could use column C and enter a Rank function.

1.In cell C2, enter this formula: =RANK(B2,$B$2:$B$51)<6

2.Copy the formula from C2 to C2:C51


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
MS Excel Functions Select a random sample of rows in Excel Tutorial

View Tutorial:
MS Excel Functions Select a random sample of rows in Excel Tutorial

Related Tutorials:

Accelerate your Java apps! - JavaWorld - September 1998
Accelerate your Java apps! - JavaWorld - September 1998
 
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
Java Tip 77: Enable copy and paste functionality between Swing's JTables and Excel - JavaWorld
 
XSL gives your XML some style - JavaWorld June 2000
XSL gives your XML some style - JavaWorld June 2000
 
Eliminate tedious programming: Recover data with XML and Reflection - JavaWorld November 2000
Eliminate tedious programming: Recover data with XML and Reflection - JavaWorld November 2000
 
Combine the power of XPath and JSP tag libraries - JavaWorld January 2001
Combine the power of XPath and JSP tag libraries - JavaWorld January 2001
 
XML APIs for databases - JavaWorld January 2000
XML APIs for databases - JavaWorld January 2000
 
Think small: Java on Compaq's iPAQ
Think small: Java on Compaq's iPAQ
 
Flex your grid layout
Flex your grid layout
 
Customize SwingWorker to improve Swing GUIs
Customize SwingWorker to improve Swing GUIs
 
Interesting concept ...
Interesting concept ...
 
Excelling in Excel with Java
Excelling in Excel with Java
 
The HTML Renderer Shootout, Part 1
The HTML Renderer Shootout, Part 1 In this article, we will review 11 different HTML renderers, comparing their features, compliance, and speed; searching for the best one for any project.
 
They just work
Writing CSV files: CSVPrinter This class makes it easy to output CSV. Given values, it will automatically determine if they need to be quoted and escape special characters. Comments can easily be written and correct line beginnings will be added.
 
Gain SQL SELECT functionality in Java
Gain SQL SELECT functionality in Java Summary In "Filter Collections," David Rappoport described a simple way to filter collections of objects. In this article, he expands on this idea and shows you how to treat an array or a collection of objects the s
 
Sun Repricing Select Sun StorEdge 3000 Arrays
To provide customers with affordable storage products, Sun is reducing its price on the Sun StorEdge 3310 SCSI Array, Sun StorEdge 3510 FC Array, and Sun StorEdge 3511 FC Array with SATA.
 
Manage Database Metadata with POI and Excel
Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.
 
Using Beans in JSP. A brief introduction to JSP and Java Beans.
Using Beans in JSP. A brief introduction to JSP and Java Beans. USING BEANS IN JSP Java Beans Java Beans are reusable components. They are used to separate Business logic from the Presentation logic. Internally, a bean is just an instance of a
 
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us.
Buy SuSe 9.1 Personal CDs in India from us. Suse 9.1 Personal is available with us. SuSe 9.1 Personal Linux Now Available SuSe 9.1 Personal CD's SuSE 9.1 Personal Edition was based on the x86 port of the Personal Edition, and it includes all of
 
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets. Using MYSQL Database with JSP & Servlets. MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it
 
DB Visual Architect for Eclipse
DB Visual Architect for Eclipse (DBVA-EC) is a full featured Object Relational Mapping (ORM) plugin for Eclipse that provides the industry\'s best round-trip code engineering support with Java.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.