In this WB, I have to rows of names being filled out - how do I get them to combine in the bottom one, without spaces.
https://www.excelforum.com/attachmen...1&d=1493718539
In this WB, I have to rows of names being filled out - how do I get them to combine in the bottom one, without spaces.
https://www.excelforum.com/attachmen...1&d=1493718539
Why 2 tables ? ... this only makes life more difficult if you want to combine into a single list.
Beacuse they are 2 seperate groups of people that needs to be able to be distinguished to the "bear" eye when filling it out
I only need the names "pulled down"
Last edited by HereComesTheBoom; 05-02-2017 at 05:58 AM.
Try
in D30
=IFERROR(IF(ROWS($1:1)<=COUNTA($D$7:$D$26),INDEX($D$7:$D$26,ROWS($1:1)),INDEX($J$7:$J$26,ROWS($1:1)-COUNTA($D$7:$D$26))),"")
- and magic happens!
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks