Help with Formula for Unique IDs

rmalenda

Hello, I'm working on dashboard that will track a list of vendors.  Some vendors have multiple locations, so the vendor name would appear the same from row to row with other fields unique to location, while other vendors only appear once because they only have one location.  Those who have multiple locations only need to count once even though the vendor name could appear multiple times.  I'm looking for a formula that would allow me to only count unique entries from this column.  Could anyone help with this?  Thank you!

Chak Khiam

Combine the DISTINCT function with that of COUNT.

You want to count the number of vendors (assuming you name that Column as Vendor) that are not repeated - expressed as a formula:

=COUNT(DISTINCT(Vendor:Vendor))

 

 

 

rmalenda

Thank you!  This worked perfectly!