Microsoft Office Forums - View Single Post - distribute a large list among few persons

Thread: distribute a large list among few persons

View Single Post

Old

02-28-2019, 07:48 AM

bosco_yip

bosco_yip is offline

bosco_yip uses Windows 10

Windows 10 bosco_yip uses Office 2016

bosco_yip uses Office 2016

Office 2016

Novice

Join Date: Feb 2019

Location: Singapore

Posts: 7

bosco_yip is on a distinguished road

Default

Perhaps,

In "distribution" sheet C2, copied down :

=IF(A2="","",LOOKUP(ROWS($1:1),responsible!$B$2:$C $5))

Regards
Bosco

Reply With Quote