Filtering sorting the data using excel formulas-arrays

[PrimalByte]

Hi,

I've been looking for an example of this solution.
http://www.exceltactics.com/make-fil...l-using-small/

I've tried to change it for the spreadsheet attached, but I can't get it to work. I'm not sure if I'm on the track.

Data sheet contains information to replicate on the Report sheet, but filtered to just 'Outstanding'. So only rows with 'Outstanding' are listed with the data.

Thanks

If I can see example working, I will understand it quicker.

[Tony Valko]

Try this...

Data Range

	A	B	C	D	E
1	Status	Outstanding
2	------	------	------	------	------
3
4	Number	Date	ID	Customer	Comments
5	200	2/1/2015	3	Fred Ltd	Text 1
6	100	3/1/2015	4	Ben plc	Text 2
7

Enter this array formula** in A5:

=IFERROR(INDEX(Data!A:A,SMALL(IF(Data!B$2:B$5=$B$1,ROW(Data!B$2:B$5)),ROWS(A$5:A5))),"")

Enter this array formula** in B5 and copy across to E5

=IFERROR(INDEX(Data!C:C,SMALL(IF(Data!$B$2:$B$5=$B$1,ROW(Data!B$2:B$5)),ROWS(B$5:B5))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Format cell B5 as Date
Format cell C5 as General

Select the range A5:E5 and copy down until you get blanks.

[PrimalByte]

Thanks very much Tony. I'll have a go later.