Forum Discussion
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 she...
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.