Here's a brute-force calculation that will produce the value 1 if you get at least 3 values in any one record to match each other, in case that's all you need. Note, however, that it won't exclude any case where 4 or more values match.

You want to locate records that have the same value in the field numA on at least 3 different records.

You want to do the same for each of the 8 fields.

In my example records #2 and #3 share the value "9" in field numG, but since there are only two records and not three, I didn't expect that they would fit your criteria.

If you do want to find two or more records with the same value in the same field, you can search for "!" in that field. It is a special character meaning to find duplicates. After searching, sort by that field to see the matches as neighboring records.

I want to locate ANY records that have the same value in 3 fields and bring all those records in a new found set. For instance: in a record, field A, D and G have numbers 1, 4 and 6. I want to locate ALL records with numbers 1, 4 and 6 in any of 8 fields.

Here's a brute-force calculation that will produce the value 1 if you get at least 3 values in any one record to match each other, in case that's all you need. Note, however, that it won't exclude any case where 4 or more values match.

I will add only that, instead of the value "1" as the result of each true condition, you could have entered the first value on that line to find out what the triplicated value was. For example, instead of

Num B = Num C and Num B = Num E; 1;

you could have put

Num B = Num C and Num B = Num E; Num B;

Of course, then you'd need a pair of empty quotation marks ("") as the final option of the Case statement if it failed to meet any of the preceding criteria.

But now I see, after reading further downthread, that you really want to compare values across records and not merely within one. I regret that the above formula won't do that job for you.