Counting Unique Entries in a Column for LinkedIn Post Tracking

·

would anyone have an easy way to count all the unique entries in a column for an entire sheet. So if i have a table of linkedin posts, i am trying to count the posts from the 5 different companies I am tracking. I think a formula should be able to do it but not sure where to set the formula up so it runs for the entrie column and not just each row

2 comments

· Sorted by Oldest

Clay
APP
·
·
Use the Lookup Multiple Rows integration to count unique entries across your entire column. This scans the column for matching values and counts how many cells exist with each company identifier. Alternatively, click your company column header and select "Dedupe" from the dropdown to deduplicate and see unique companies. For a formula approach, add a new Formula column, then use the AI Formula Generator to prompt something like "Count unique companies in [your column name]" - it will generate the appropriate code to count across the entire column rather than per row.
Source: Formula generator | Documentation | Clay University
Peter Sabapathy
·
·
I was able to get it to work with the formula. Thanks.

Clay
APP
·
·
Use the Lookup Multiple Rows integration to count unique entries across your entire column. This scans the column for matching values and counts how many cells exist with each company identifier. Alternatively, click your company column header and select "Dedupe" from the dropdown to deduplicate and see unique companies. For a formula approach, add a new Formula column, then use the AI Formula Generator to prompt something like "Count unique companies in [your column name]" - it will generate the appropriate code to count across the entire column rather than per row.
Source: Formula generator | Documentation | Clay University
Peter Sabapathy
·
·
I was able to get it to work with the formula. Thanks.