Aug 14 2019 01:23 PM - edited Aug 14 2019 01:28 PM
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
Aug 14 2019 01:50 PM
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.