Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a specific list of rows out of a much larger excel s.
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? |
#2
|
|||
|
|||
Autofilter on the id column, DataFilterAutofilter, 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) "larkindale" wrote in message ... 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? |
#3
|
|||
|
|||
Hi
try Ron's addin: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany "larkindale" schrieb im Newsbeitrag ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |