I am trying to create a rotating list of menu items. In other words, I want it to starts at the top again once it reaches the bottom. I followed a formula I found on YouTube that rotates a list vertically (down the column):
=INDEX(Menu,IF(ROWS(C$64:C64)>$J61,ROWS(C$64:C64)-$J61,$I61+ROWS(C$64:C64)-1))
Works fine. But how do I change the formula to rotate horizontally across a row?
And how do I keep it rotating correctly onto the next row?
Thanks!
Bookmarks