Filtering/sorting the data using excel formulas/arrays

Hi everyone,

Been googling for too long. Need a way to filter data without using filters or sort function. Instead I need a function/formula/array formula that would copy the rows which meet particular condition IF in specific column. No VBA.

I have a dataset, people's profiles, with the column Status among others. When Status is "1" I'd like the profile (or row) to be copied to the specified area. I tried INDEX, MATCH, ROW, SMALL, COUNTIF, VlOOKUP, SEARCH functions, I am desperate. Please, any help would be massively appreciated.

I attached a file and the HELP file which I found really useful, but with a flaw (it doesn't copy one-condition files). My best guess it will be array (Ctrl+Shift+Enter) functions with some high-tech INDEX and MATCH functions.

Sources already used:
http://www.excelforum.com/excel-gene...sing-sort.html (FORUM)
http://www.get-digital-help.com/2009...gories-part-2/ (ATTACHED FILE, GREAT FORMULA)

https://forum.openoffice.org/en/foru...ic.php?t=38056
http://chandoo.org/wp/2008/10/22/sor...sing-formulas/

Thank you in advance!

Attached files could be found here

Thank you very much! What I was looking for!

Also this array formula: =IFERROR(INDEX($A$2:$E$16,SMALL(IF($D$2:$D$16=1,MATCH(ROW($D$2:$D$16),ROW($D$2:$D$16)),""),ROW(B2)),COLUMN(B2)),"")