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!
