Thread: extract data from one worksheet to another worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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 With QuoteReply With Quote