Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
E4=IFERROR(LARGE(ROW(INDIRECT($B$1&”:”&$B$2))*NOT(COUNTIF($E$3:E3,ROW(INDIRECT($B$1&”:”&$B$2)))),RANDBETWEEN(1,$B$2-$B$1-ROW(A1)+2)),””)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.