Formula:
=IF(MOD(ROW(),20)=1,INDIRECT("B"&(ROW()-1)/20+2),
IF(MOD(ROW(),20)=2,INDIRECT("C"&(ROW()-2)/20+2),
IF(MOD(ROW(),20)=3,INDIRECT("D"&(ROW()-3)/20+2),
IF(MOD(ROW(),20)=4,INDIRECT("E"&(ROW()-4)/20+2),
IF(MOD(ROW(),20)=5,INDIRECT("F"&(ROW()-5)/20+2),
IF(MOD(ROW(),20)=6,INDIRECT("G"&(ROW()-6)/20+2),
IF(MOD(ROW(),20)=7,INDIRECT("H"&(ROW()-7)/20+2),
IF(MOD(ROW(),20)=8,INDIRECT("I"&(ROW()-8)/20+2),
IF(MOD(ROW(),20)=9,INDIRECT("J"&(ROW()-9)/20+2),
IF(MOD(ROW(),20)=10,INDIRECT("K"&(ROW()-10)/20+2),
IF(MOD(ROW(),20)=11,INDIRECT("L"&(ROW()-11)/20+2),
IF(MOD(ROW(),20)=12,INDIRECT("M"&(ROW()-12)/20+2),
IF(MOD(ROW(),20)=13,INDIRECT("N"&(ROW()-13)/20+2),
IF(MOD(ROW(),20)=14,INDIRECT("O"&(ROW()-14)/20+2),
IF(MOD(ROW(),20)=15,INDIRECT("P"&(ROW()-15)/20+2),
IF(MOD(ROW(),20)=16,INDIRECT("Q"&(ROW()-16)/20+2),
IF(MOD(ROW(),20)=17,INDIRECT("R"&(ROW()-17)/20+2),
IF(MOD(ROW(),20)=18,INDIRECT("S"&(ROW()-18)/20+2),
IF(MOD(ROW(),20)=19,INDIRECT("T"&(ROW()-19)/20+2),
IF(MOD(ROW(),20)=0,INDIRECT("U"&(ROW()-20)/20+2)))))))))))))))))))))
Formula:
=IFERROR(INDEX($W$1:$W$800,MATCH(1,INDEX((COUNTIF($X$1:X1,$W$1:$W$800)=0)*($W$1:$W$800<>""),0),0)),"")
Bookmarks