Extract List of Unique Values

Neil Watson
Neil Watson ✭✭✭✭✭✭
edited 07/20/23 in API & Developers

Hi

Is it possible to use Bridge to extract from a column a list of values, run a JS to extract an array of unique values, and then pass this to another sheet and update another column with this unique list?

Tags:

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Neil Watson You should be able to use the LOWER function for evaluation but still output the version that includes caps.

    =IFERROR(INDEX(DISTINCT(LOWER(COLLECT(.....................))), 1), "")


    I haven't tested it yet, but I feel like it should work.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Right. There are already a number of posts here in the community detailing how to pull a distinct or unique list from another sheet via formula. It usually involves the formula above without the LOWER function. The number 1 would output the first distinct value. Changing that to a 2 will output the second distinct value, so on and so forth. I usually use a helper column with the numbers manually entered so I can apply it as a column formula.

Answers