Yes.
And if you name the data tbl, you can simplify the formula to
=INDEX(tbl, MOD(E2-1, ROWS(tbl)) + 1, INT((E2-1) / ROWS(tbl)) + 1)
Yes.
And if you name the data tbl, you can simplify the formula to
=INDEX(tbl, MOD(E2-1, ROWS(tbl)) + 1, INT((E2-1) / ROWS(tbl)) + 1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks