Hello every one,
I have a largish data set and I want to have a dynamic formulae that returns only the ordered items. it will then go in a new sheet for it to be printed with out hassle by other staff. I know i can do it by advanced filter but need it to be dynamic so i dont have to do it every time..
i have researched it a bit but am falling over somewhere can anyone help...??
I have completed a sumproduct to find all entries that have order qty's
=SUMPRODUCT(($I$3:$I$102>0)+($J$3:$J$102>0)) this give me the right 1st step. But
this is not working...why?
=if(row(S$16:S16)>$S$13,"",index(A$3:A$102,small(if(SUMPRODUCT(($I$3:$I$102>0)+($J$3:$J$102>0))),row($A$3:$A$102)-row($A$3)+1),row(S$16:S16)),"")
thank you for your time...
I have a largish data set and I want to have a dynamic formulae that returns only the ordered items. it will then go in a new sheet for it to be printed with out hassle by other staff. I know i can do it by advanced filter but need it to be dynamic so i dont have to do it every time..
i have researched it a bit but am falling over somewhere can anyone help...??
I have completed a sumproduct to find all entries that have order qty's
=SUMPRODUCT(($I$3:$I$102>0)+($J$3:$J$102>0)) this give me the right 1st step. But
this is not working...why?
=if(row(S$16:S16)>$S$13,"",index(A$3:A$102,small(if(SUMPRODUCT(($I$3:$I$102>0)+($J$3:$J$102>0))),row($A$3:$A$102)-row($A$3)+1),row(S$16:S16)),"")
thank you for your time...
