Formula to Count Unique Items in a Single Column

Léa Henry

·

within one colum with multiple items, I want to get the unique number of each item - which formula to get this result ?

4 comments

· Sorted by Oldest

Clay
APP
·
·
Use the "Count Occurrences of Items with Clay" integration to get unique counts of each item in a column. Alternatively, you can use AI formulas: 1. Choose "Ask question about items with AI" from the column options 2. Use the formula option and prompt the AI to count occurrences of each item 3. The AI will generate the appropriate code for your desired output The Count Occurrences integration accepts text or arrays, lets you set separators (defaults to space), and can limit results to top recurring items.
Sources: Count Occurrences of Items with Clay AI Formulas + Conditional Runs [CRM Enrichment] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Léa Henry
·
·
which prompt should I write with Count Occurrences of Items with Clay ? It seems it doesn’t count each item from the colum but each word within one cell of a column
Clay
APP
·
·
The Count Occurrences integration counts words/items within text, not across different cells in a column. By default, it uses space as the separator, so it counts each word in a cell. To count unique items across multiple cells in a column, use AI formulas instead: 1. Add a new "formula" column 2. Reference your data column 3. Prompt: "Count the unique occurrences of each item in this column" 4. The AI will generate code to count each unique value across all cells The Count Occurrences tool is designed for analyzing text content within individual cells, not for aggregating data across an entire column.
Sources: Count Occurrences of Items with Clay AI Formulas + Conditional Runs [Clay 101] - Clay University
Daniel Kupka (Clay)
·
·
Hey Lea, thanks for reaching out. I think you might have what you need here, so I'll tentatively mark this closed for the moment. Please keep in touch if you hit other roadblocks!

Clay
APP
·
·
Use the "Count Occurrences of Items with Clay" integration to get unique counts of each item in a column. Alternatively, you can use AI formulas: 1. Choose "Ask question about items with AI" from the column options 2. Use the formula option and prompt the AI to count occurrences of each item 3. The AI will generate the appropriate code for your desired output The Count Occurrences integration accepts text or arrays, lets you set separators (defaults to space), and can limit results to top recurring items.
Sources: Count Occurrences of Items with Clay AI Formulas + Conditional Runs [CRM Enrichment] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Léa Henry
·
·
which prompt should I write with Count Occurrences of Items with Clay ? It seems it doesn’t count each item from the colum but each word within one cell of a column
Clay
APP
·
·
The Count Occurrences integration counts words/items within text, not across different cells in a column. By default, it uses space as the separator, so it counts each word in a cell. To count unique items across multiple cells in a column, use AI formulas instead: 1. Add a new "formula" column 2. Reference your data column 3. Prompt: "Count the unique occurrences of each item in this column" 4. The AI will generate code to count each unique value across all cells The Count Occurrences tool is designed for analyzing text content within individual cells, not for aggregating data across an entire column.
Sources: Count Occurrences of Items with Clay AI Formulas + Conditional Runs [Clay 101] - Clay University
Daniel Kupka (Clay)
·
·
Hey Lea, thanks for reaching out. I think you might have what you need here, so I'll tentatively mark this closed for the moment. Please keep in touch if you hit other roadblocks!