Combine Two Similar Arrays
 

I got the basic Arrays from these discussion boards and individually they
work masterfully. However I was wondering how I can actually combine them so
that I can actually have a single list of information instead of several
individual ones.

Below is the function codes...

=IF(ROWS(S$2:S2)COUNTIF(C12:M12,"0"),"",INDEX(C$ 11:M$11,SMALL(IF(C$12:M$120,COLUMN(C$11:M$11)),RO WS(S$2:S2))-COLUMN($C11)+1))


=IF(ROWS(S$13:S13)$M$2,"",INDEX(C$18:Q$18,SMALL(I F(C$19:Q$190,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1))


Thanks in Advance,
Rob

Combine Two Similar Arrays
 

Rob wrote:
I got the basic Arrays from these discussion boards and individually they
work masterfully. However I was wondering how I can actually combine them so
that I can actually have a single list of information instead of several
individual ones.

Below is the function codes...

=IF(ROWS(S$2:S2)COUNTIF(C12:M12,"0"),"",INDEX(C$ 11:M$11,SMALL(IF(C$12:M$120,COLUMN(C$11:M$11)),RO WS(S$2:S2))-COLUMN($C11)+1))


=IF(ROWS(S$13:S13)$M$2,"",INDEX(C$18:Q$18,SMALL(I F(C$19:Q$190,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1))


Thanks in Advance,
Rob


Maybe if you provided a sample of the original data and the desired results...