| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract data from one worksheet to another worksheet
Sheet 2
B2: =IF(ISERR(SMALL(IF(Fruit=$A$2,ROW(INDIRECT("1:"&RO WS(Fruit)))),ROWS($1:1))),"",INDEX(Logic,SMALL(IF( Fruit=$A$2,ROW(INDIRECT("1:"&ROWS(Fruit)))),ROWS($ 1:1)))) ctrl+shift+enter, not just enter copy down "Jeff" wrote: I have a list of data on one worksheet: Apples True Banana False Apples False I want to pull just the Apples and the corresponding data (true, false) to a new worksheet without sorting and cutting and pasting. Is there a function that will do this for me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a worksheet and extract data | Excel Worksheet Functions | |||
| Extract data from one worksheet | Excel Worksheet Functions | |||
| Using a column of data from 1 worksheet to extract data from another worksheet | Excel Worksheet Functions | |||
| Extract data from one Worksheet to another | Excel Worksheet Functions | |||
| extract data from worksheet | Excel Worksheet Functions | |||
Hybrid Mode
