R
Rob
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$12>0,COLUMN(C$11:M$11)),ROWS(S$2:S2))-COLUMN($C11)+1))
=IF(ROWS(S$13:S13)>$M$2,"",INDEX(C$18:Q$18,SMALL(IF(C$19:Q$19>0,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1))
Thanks in Advance,
Rob
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$12>0,COLUMN(C$11:M$11)),ROWS(S$2:S2))-COLUMN($C11)+1))
=IF(ROWS(S$13:S13)>$M$2,"",INDEX(C$18:Q$18,SMALL(IF(C$19:Q$19>0,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1))
Thanks in Advance,
Rob