Create summary but eliminate redundant records with same company name
I imported a database that includes the list of every casino in the US along with the number of gaming machines they have. The database also included the name of each key manager at each casino, making the database rather large (20,000 records). There are only about 1300 unique casinos, of which I want to create list and sort by the number of gaming machines. The problem is the list will not eliminate the redundant records. In other words, I just need each casino to be listed once. Is there a way to eliminate the redundant casino names after the first one has been identified? I know I can do this in excel using a VLookup function but not sure how to do this in Filemaker.
See example that I created in excel to show you what is happening and what I need as it relates to the found (and sorted) records.