Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-14-2017, 08:40 PM
H28Sailor H28Sailor is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Mar 2013
Posts: 55
H28Sailor is on a distinguished road
Default selecting a subset of rows from a spreadsheet

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 ?
Reply With Quote
  #2  
Old 07-17-2017, 05:32 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 819
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Filtering.
Reply With Quote
Reply

Tags
sorting rows

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 11:52 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft