Removed this question since I asked it on the OpenOffice forum. Sorry, I didn’t realize they were shared sites / forums.
Please see better explained issue for deleting duplicate entries on OpenOffice Forum
You should possibly study Apache OpenOffice Community Forum - [Tutorial] Randomization in Calc - (View topic).
Thank you, I appreciate the link to that site. I didn’t even know it existed. Unfortunately however, my issue isn’t dealing with integers and comparing Min / Max. My issue is removing duplicate text from 2 or more columns.
Cross posted on the OpenOffice forum.
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
You might also consider to share details of your operating system and the version of LibreOffice you are using.
This isn’t consistent with {Row 3 as an example}:
“Not show”! <> “Remove”.
Your question is rather complicated and very special. Consequently you should be specifically precise about the details.
isn’t consistent with
Of course this is about integers to be used as indices. And you surely will select the entries for columns B and C using random indices into your original list of words.
To “not show” words repeate for the same row the obvious solution is to use condtional formatting.
“Remove” can’t be done by a formula. If you mean “not choose”.
- Are you asking for a Sub or for formulas?
- Is there a substitute for the “removed” choice?
Also: regard that RANDARRAY() is volatile.