Help

Get unique words out of an array?

506 0
cancel
Showing results for 
Search instead for 
Did you mean: 
N_H
4 - Data Explorer
4 - Data Explorer

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_20201104202128 Screen Capture_select-area_20201104202838 Screen Capture_select-area_20201104202904

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.

0 Replies 0