Snasui Excel Forum

Hi there!
I need your help how to write formula to return only non zero value from two different columns and place them in a column

I attach a sample template as well


TY

...

G7

=IFERROR(IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$7:$B$16)/($B$7:$B$16>0),ROWS($G$7:G7))),INDEX(C:C,AGGREGATE(15,6,ROW($D$7:$D$16)/($D$7:$D$16>0),ROWS($G$7:G7)-SUMPRODUCT(--($B$7:$B$16>0))))),"")

Norkaz

TY