Pull Data from a column in Excel for a Summery Sheet

[NatePopo]

Hey,

I have attached a very basic excel spreadsheet which we use to check stock level. In column H a formula calculates whether any product should be ordered. I would like to create a summery sheet pulling only the products that require ordering (the products in green), is there a way to do this in Excel? I fairly new to Excel and so not familiar with all of its functions.

Any help will be much appreciated!

Thanks, Nate

[#2]

@NatePopo 

Hi Nate,

The formula could be like

=IFERROR(INDEX(Sheet1!B$9:B$2000,AGGREGATE(15,6,1/(Sheet1!$G$9:$G$2000>0)*(ROW(Sheet1!$G$9:$G$2000)-ROW(Sheet1!$G$8)),ROW()-ROW($B$4))),"")

drag it down and to the right, please see Sheet2 in attached. I only changed in your IFS formula "0" on 0 to have numbers in entire column.