Skip to main content

I have a table where we have products defined something like:


Product name | Client | Other product info


In another table, we have the columns:


Products selected | Client


You select multiple products for Products selected and the Client column is a lookup.


However, the same client shows up multiple times in the Client field if more than one of their products is selected. Is there a way to show any given client a single time in the Client field?


I had hoped that using a new field, Client unique with the ARRAYUNIQUE function would do it. But ARRAYUNIQUE only seems to work on numeric arrays.


Any idea how to accomplish this?


Thanks.

ARRAYUNIQUE should work, just make sure you don’t have an extra space before/after a client name that would force it to be unique

ARRAYUNIQUE should work, just make sure you don’t have an extra space before/after a client name that would force it to be unique


Thanks. I had not explored rollup fields. So a rollup field with ARRAYUNIQUE(values) did it.


Thanks.

Thanks. I had not explored rollup fields. So a rollup field with ARRAYUNIQUE(values) did it.


Thanks.


I just reread your post and noticed you were using lookup. You beat me by 30s to mention rollup

I just reread your post and noticed you were using lookup. You beat me by 30s to mention rollup


I marked yours as a solution… I figured it out as I was going but wanted to credit you.

Reply


Terms & Conditions