| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract data from one worksheet
I would like to extract matched data from one worksheet and put into another.
For example, a table contains two columns, country and city, Country City CN SZ CN BJ USA SEA USA SFO On a blank worksheet, enter "USA" in A1, how can I copy only the last two rows? I try INDEX & MATCH functions, it always finds the first row. How can I tell the Excel to make a on-going MATCH until it finish an array? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| Data From One Worksheet To Be Used In A Cell In A Different Worksheet | Excel Worksheet Functions | |||
| Extract data from one Worksheet to another | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Threaded Mode
