| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New list from two workbooks
I have a worksheet with 34000 rows, and another which has 923 rows - which
are in the 34k. How do I filter the 34k sheet with just the 923 ? -- Dave Eade EPCS Ltd www.EPCS.me.uk |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New list from two workbooks
Assume 34k data in Sheet1's col A, 923 data in Sheet2's col A, from row2 down
In Sheet1, In B2: =IF(A2="","",--ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$924,0))) Copy down all 34k rows. Kill formulas. Apply autofilter on col B. Col B returns: 1 for items in col A found in Sheet2's col A, 0 for items not found, and blanks: "" for any empty cells in col A. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave Eade" wrote: I have a worksheet with 34000 rows, and another which has 923 rows - which are in the 34k. How do I filter the 34k sheet with just the 923 ? -- Dave Eade EPCS Ltd www.EPCS.me.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| how do i create a drop-down list using workbooks? | Excel Worksheet Functions | |||
| 70 WORKBOOKS - NEED PIECES OF DATA FROM EACH TO FORM LIST | Excel Discussion (Misc queries) | |||
| Generating a report list and statistic worksheet in Excel from other workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
