selecting a subset of rows from a spreadsheet

H28Sailor · #1 07-14-2017, 08:40 PM

I have the following situation:-

I am given a spreadsheet with many rows
One of the fields is an ID number
I am selecting at random a subset of this data and returning a list of ID numbers for the rows I wish to use in the future

What is the easiest way for the compiler of the original set of data to produce a subset of this data with just the rows with the ID numbers I have given him ?

gebobs · #2 07-17-2017, 05:32 AM

Filtering.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying rows from one spreadsheet to another	Colonel Biggs	Excel	3	02-15-2015 08:23 AM
Trying to import specific data from one spreadsheet to another, without matching rows	Wynka	Excel	0	11-26-2014 09:33 AM
Selecting values from different rows in a table and sort them in order in a single row	FromF	Excel	2	09-09-2014 02:30 AM
Using functions to restructure data in spreadsheet from rows to cols	ghumdinger	Excel	1	07-28-2014 08:06 AM
Delete Blank Rows (Cyrillic Text in Spreadsheet )	dozd	Excel	1	02-22-2013 03:24 AM