# Looking for unique value function

**URL:** <https://community.hubspot.com/t/looking-for-unique-value-function/66846>\
**Category:** Data Hub\
**Tags:** datasets\
**Created:** [October 11, 2022, 9:40am UTC](https://community.hubspot.com/t/looking-for-unique-value-function/66846 "2022-10-11T09:40:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bhascher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bhascher/32/39140_2.png) [@bhascher](https://community.hubspot.com/u/bhascher)\
**Post date:** [October 11, 2022, 9:40am UTC](https://community.hubspot.com/t/looking-for-unique-value-function/66846/1 "2022-10-11T09:40:46Z")

</div>

Hi, my team is trying to report on number of unique companies out of a contact list. It looks like the only way of doing this wihtin HubSpot is to use a HubSpot Dataset. We couldn’t find it but, Is there a Unique Value function in Dataset that we can use in order to get that number pushed out?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [October 11, 2022, 9:49am UTC](https://community.hubspot.com/t/looking-for-unique-value-function/66846/2 "2022-10-11T09:49:46Z")

</div>

Hi @bhascher,

If you’re really just interested in the count of companies, you could also use the list tool. Create a **company** -based list and use the contact properties filters to re-create the filters from your **contact** list.

For example, if your contact list (the one from your original post) filters for all contacts with a certain _Lifecycle stage_ or is a static list generated from an import, you would create a company list and filter for all companies that are associated with contacts with _Lifecycle stage_ so and so or from the _Import_ so and so.

(If this static list was assembled manually, you would have to assign them a value in any property, existing or custom, that would let you filter for them in the company list.)

The company list would automatically show unique company records only, not the same record multiple times. The list count would be the number you’re looking for.

Best regards!

---

<div class="post-metadata">

**Author:** ![bhascher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bhascher/32/39140_2.png) [@bhascher](https://community.hubspot.com/u/bhascher)\
**Post date:** [October 11, 2022, 2:19pm UTC](https://community.hubspot.com/t/looking-for-unique-value-function/66846/3 "2022-10-11T14:19:42Z")

</div>

Thx Karsten, pff somehow we missed that easy option 😬!