How do I get a specific list of rows out of a much larger excel s.

G

Guest

I have a large matrix of data in excel, which is about 20 columns and 22,000
rows. Each row is identified by a unique identifier. I freqently need to
pull out the data for up to 1,000 rows at a time. Is there a function on
excel that would allow me to easily do this without searching for each
identifier individually?
 
B

Bob Phillips

Autofilter on the id column, Data>Filter>Autofilter, and select by your
target id. This will hide all other rows, and you can then copy off the
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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.

Ask a Question

Similar Threads

return unique data from a list 4
Unique identifier 18
Pivot tables - how do I change default from "count of" to "sum of" 2
Advanced compare of two worksheets 2
No. of columns in a Pivot Table 1
Line up rows to corresponding row of larger master list in excel 13
How to update a portion of rows and columns between two files 1
Drop-down list Populated by a Subset of a larger list 3

Top