- Aug 14, 2020
- Office Version
I am looking for a way to pull a random piece of data from a table, and skip the blanks and ensure there are no duplicates. The farthest I have gotten is by using <=INDEX('Sheet 1'!E8:G68,RANDBETWEEN(1,ROWS('Sheet 1'!E8:G68)),1), but this formula pulls the empty boxes. Not sure if this will pull duplicates, I haven't seen any yet. Thanks in advance!