做个样表,详见截图,这里只做3个人3天的数据,根据你实际自己涛吧
C33输入
=LOOKUP(1,0/(($B$3:$B$34=INDIRECT("$A"&IF(MOD(ROW(),2)=0,ROW()-1,ROW())))*($D$3:$D$34=C$36)),$E$3:$E$34)
C34输入
=LOOKUP(1,0/(($B$3:$B$34=INDIRECT("$A"&IF(MOD(ROW(),2)=0,ROW()-1,ROW())))*($D$3:$D$34=C$36)),$H$3:$H$34)
选中C33:c34,下拉再右拉