Need a calc for counting a unique value
I'm drawing a blank how to do this elegantly using either an ExecuteSQL calc or "straight" FileMaker calc so I need some help.
There's a field in a table named CompanyName__lxt where whenever a user either copies a record or creates a new one _and_ enters a company name--either manually or already entered from the duped record--it's checked against all the records in a table for the same company name and gives a count of those uses. For example, if a user enters Bozotronics into the CompanyName__lxt field and that company name already exists in to two other records, the calc presents a  since s/he just entered Bozotronics for the third time.
I already have the tail end of the calc figured out so if there is a count of more than one then conditional formatting will cause the field's text to turn yellow; it's the front end I'm having trouble with.
As always, your help is appreciated.