HoneyBadger914
New Member
- Joined
- Aug 14, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
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!