Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Count Company Occurrences in a Data Column Efficiently

·

·

Hey Team I have a question Is it possible that we count how many times a company repeats in a column? Like Row No Company Company count (Needed) Row 1 Acushnet 1 Row 2 Acushnet 2 Row 3 Acushnet 3

Count Company Occurrences in a Data Column Efficiently | Clay

9 comments

· Sorted by Oldest

Clay
APP
·
·
Yes, you can count company occurrences using the Lookup Multiple Rows integration. This scans your company column and counts matching values, displaying the count for each row. Alternatively, use the Count Occurrences integration if you need to count items within text or arrays. Both methods will give you the company count column you're looking for, showing "3" for each Acushnet row in your example.
Source: Count Occurrences of Items with Clay
Aman
·
·
https://app.clay.com/workspaces/410859/workbooks/wb_0swlld79wbjKAU9fo4F/tables/t_0syd0a6SUvxxWFnb62Z/views/gv_0sy598nhNxVMpZTvnj9
Clay
APP
·
·
Hi Aman, Thanks for reaching out to support. Would you be able to provide a bit more context on your issue, and what you are hoping to achieve. -Nicole
Aman
·
·
I need to count company names in a column is there a way to do that
Bo (Clay)
·
·
Yep, you can use a Lookup in the table based on the domain to count how many times each company appears. That’ll give you a clear count of variations across the column. Let me know if you want help setting it up.
Aman
·
·
I have tried lookup multiple rows in a table but that is giving max amount number like this Input output Calumet 3 Calumet 3 Calumet 3 I want like this Input output Calumet 1 Calumet 2 Calumet 3
Aman
·
·
can you help in achiving this?
Bo (Clay)
·
·
This Loom should help clarify how to set that up: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7 Let me know if you’d like help applying it to your table.
Aman
·
·
Hey that was really helpful thanks problem is solved man