I have text files that are imported into Excel, then Filemaker. I need to serach the contents of one of the fields, named "TheirCounty", then assign a value of 1 into another field. Then repeat until all the counties there are found Then the fields that had the 1 inserted into them are summed up with a total number of different counties that were contacted. 1 point per county, with only only no matter how many separate instances of the county showing up in the "TheirCounty" field.
The summing works okay, but I'm having a tough time performing what should be pretty simple. I've attached the work in progress.