I am in need of assistance on a way to select certain cells in a sheet and export them to a TXT file. I can do it if they are all in the same row or column, but nothing I've tried works for say A1, B2, C3 and D5. Any thoughts?
I am in need of assistance on a way to select certain cells in a sheet and export them to a TXT file. I can do it if they are all in the same row or column, but nothing I've tried works for say A1, B2, C3 and D5. Any thoughts?
Try this ...
=INDIRECT(INDEX({"A1","B2","C3","D5"},RANDBETWEEN(1,4)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks