# Count duplicates

**URL:** <https://community.glideapps.com/t/count-duplicates/73697>\
**Category:** Ask for Help\
**Created:** [May 27, 2024, 5:18pm UTC](https://community.glideapps.com/t/count-duplicates/73697 "2024-05-27T17:18:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![barneylodge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/barneylodge/32/70676_2.png) [@barneylodge](https://community.glideapps.com/u/barneylodge)\
**Post date:** [May 27, 2024, 5:18pm UTC](https://community.glideapps.com/t/count-duplicates/73697/1 "2024-05-27T17:18:41Z")

</div>

I am sure this is simple.

I have a table of reports that contain the email address of someone being reported. I want to count multiple instances of reports containing the same email address.

Help??

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 27, 2024, 5:58pm UTC](https://community.glideapps.com/t/count-duplicates/73697/2 "2024-05-27T17:58:08Z")

</div>

Create a relation linking the email to itself. Then create a Rollup counting the number of items in the relation.

---

<div class="post-metadata">

**Author:** ![barneylodge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/barneylodge/32/70676_2.png) [@barneylodge](https://community.glideapps.com/u/barneylodge)\
**Post date:** [May 28, 2024, 10:00am UTC](https://community.glideapps.com/t/count-duplicates/73697/3 "2024-05-28T10:00:29Z")

</div>

Thanks!! Struggled for some reason, but all OK now

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 4, 2024, 10:01am UTC](https://community.glideapps.com/t/count-duplicates/73697/4 "2024-06-04T10:01:26Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
