Forum Discussion
Help with formula!!
Hello All, I am trying to create a formula that will extrude text and number which are in two separate columns and report it in a different column! What I have done was made a sum formula that su...
Hi,
That could be
=IFERROR(INDEX($L$4:$L$18 & " QTY" & $M$4:$M$18,AGGREGATE(15,6,1/($M$4:$M$18>0)*(ROW($L$4:$L$18)-ROW($L$3)),ROW()-ROW($P$3))),"")
starting from P4 and drag it down
Hi,
That could be
=IFERROR(INDEX($L$4:$L$18 & " QTY" & $M$4:$M$18,AGGREGATE(15,6,1/($M$4:$M$18>0)*(ROW($L$4:$L$18)-ROW($L$3)),ROW()-ROW($P$3))),"")
starting from P4 and drag it down
Thanks I got it!
I see, it was AGGREGATE(36,...) instead of 15.
Glad to help