Combine Two Similar Arrays

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
 
G

Glenn

Rob said:
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


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

Rob

For a Certain Work Group.....
Range C11:M11 Contains Names of Individuals
Range C12:M12 Contains # of Tasks Remaining
_________________________________________________________

For a completely Separate group of people......
Range C18:Q18
Range C19:Q19 Similar as above but completely different people and tasks

--------------------------------------------------


What I am currently doing is using the previous supplied formula I found in
these groups/forums to provide two independent lists of those who still has
work to be done and the list is produced dynamically and constantly as it is
an array.



I hope that helps.

Thanks for you help & time.
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top