Forum Discussion

ReneeGraham's avatar
ReneeGraham
Copper Contributor
Aug 25, 2022

Need a formula that looks for a value >0, in multple worksheets

I need a formula that looks at a cell that has a value > 0, and returns the data for the whole row to a "master" worksheet.  It has to look across several worksheets (and that is where I am getting confused)

 

Details

 

Sheet 1 is the Master and will collect all the data from the rows of the other sheets with a value of >0 in column C

 

Sheet 2 - 4 have data and text in columns A B and the value in C

 

So would it be best to use an if formula or a sumif and how do I nest it?

 

Thank you!

 

 

Formulas and Functions

2 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Aug 25, 2022

    ReneeGraham 

    This is a task that's considerably easier with access to VSTACK.

    =LET(stack,UNIQUE(VSTACK(One:Three!A2:C15),,1),f,FILTER(stack,TAKE(stack,,-1)>0),VSTACK(header,f))

     

    Without VSTACK, my recommendation is to consolidate the sheets because they contain the same type of data and the same headers. It's best to keep 'like data' together in one sheet, if possible.