I’m creating a file that pulls randomized, sorted words in 3 separate columns (A, B, and C) with 5 rows each. The data comes from an already created list of words (e.g. Carrot, Apple, Orange, Banana, Grape etc. )
The formula I’m using to create the randomize lists is below:
=INDEX(SORTBY(D1:D5, RANDARRAY(ROWS(D1:D5))), SEQUENCE(5))
What I’m trying to do is compare col B with col A and if the word already exists in A, not show it in B and compare C with A & B and if either of those columns contain that word, not show it as well in that specific row.
Example:
The script randomly selects the word Apple for col A for row 3. If the script randomly selects Apple for B AND / OR C for row 3 as well, the word “apple” will not be shown in those cells for B or C (but keep it in col A). It will just be a blank cell. If col A doesn’t contain the word Apple but col B does, then I wouldn’t want col C outputting Apple in that particular cell in that specific row.
I’ve tried a few IF functions to accomplish this with no success and all of my internet searching isn’t coming up with a working solution.
Any help would be appreciated!