Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
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
Old 07-17-2017, 05:32 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

Reply With Quote

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 01:04 PM.

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