Hi,
put this in I2 and drag down
Formula:
=IFERROR($B$2&": "&$C$2&" - "&INDEX($E$2:$E$5,INT((ROW(A1)-1)/ROWS($G$2:$G$10))+1)&" "&INDEX($G$2:$G$10,MOD(ROW(A1)-1,ROWS($G$2:$G$10))+1),"")
Hi,
put this in I2 and drag down
Formula:
=IFERROR($B$2&": "&$C$2&" - "&INDEX($E$2:$E$5,INT((ROW(A1)-1)/ROWS($G$2:$G$10))+1)&" "&INDEX($G$2:$G$10,MOD(ROW(A1)-1,ROWS($G$2:$G$10))+1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks