Forum Discussion

NatePopo's avatar
NatePopo
Copper Contributor
Aug 14, 2019

Pull Data from a column in Excel for a Summery Sheet

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

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 14, 2019

    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.

Resources