If the data being returned is TEXT then you can shorten it to:
=T(INDIRECT("'Full Survey'!B"&ROWS(B$3:B3)*31))
If the data being returned is TEXT then you can shorten it to:
=T(INDIRECT("'Full Survey'!B"&ROWS(B$3:B3)*31))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks