Get unique words out of an array?

I used this guide to create my current setup.

I am trying to take get a list of words that are unique across the “sentences” column as the “Word array Rollup).”

Screen Capture_select-area_20201104202838

So currently “Sentences” under the “Calc” sheet is taking values from “Sentences” on the “Sentences and words” sheet. The rollup “@WordArray” then creates an array from the values in that linked list. Finally, back on the first sheet I want to take unique words from the rollup “@WordArray” on the “calc” sheet. However, currently I am getting whole sentences.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.