How to Select Only Two Contacts from the Same Company in a List Automatically?

Hi All! Does anyone know if you have multiple contacts from the same company in a list, if there is a way to select only 2(not manual of course)?

· Sorted by Oldest

Hi All! Does anyone know if you have multiple contacts from the same company in a list, if there is a way to select only 2(not manual of course)?

· Sorted by Oldest

Abdul S.
·
·
are you trying to do this in excel/google sheets, or in a clay table?
Jimte K.
·
·
In sheets this would be easy. I am looking if this is a function in Clay/or via a formula
Abdul S.
·
·
yes, you can do this directly in clay. use group by company domain, then create a rank/order column for contacts within each company and filter to keep only the first 2 contacts per domain.

Abdul S.
·
·
are you trying to do this in excel/google sheets, or in a clay table?
Jimte K.
·
·
In sheets this would be easy. I am looking if this is a function in Clay/or via a formula
Abdul S.
·
·
yes, you can do this directly in clay. use group by company domain, then create a rank/order column for contacts within each company and filter to keep only the first 2 contacts per domain.