Search/Sort Formula Help Needed
 

Names
Data =Feuil1!$A$2:$A$20
info =Feuil1!$B$2:$B$20


=IF(ROWS($1:1)<=COUNTIF(info,"complete"),INDEX(Dat a,SMALL(SI(info="complete",ROW(INDIRECT("1:"&ROWS( Data)))),ROWS($1:1))),"")
Valid with SHIFT+CTRL+ENTER

http://cjoint.com/?cktqpLRFkx


JB
http://boisgontierjacques.free.fr/


On 10 fév, 18:36, Scott wrote:
I have a workbook that I need help with that is set up like so:

Sheet1: *Main Database (this sheet is the master data list.)
Sheet1 is set up as so:

A_______B______________
Data1 * * Needs Information
Data2 * * Needs Information
Data3 * * Complete
Data4 * * Needs Information
Data5 * * Complete

Now, on Sheet2 I would like to display all of the rows that say "Complete"
in ColumnB. *I would like for the final display in Sheet2 to read as:

A_______B______
Data3 * * Complete
Data5 * * Complete

How do I do this? *

Thanks!