I have array where in column 3 contains names, see attached image. I want to remove the row that is not duplicated in other words has different name, for example grace in the image. The logic approach I want to use to is: if all rows in column 3 are not equal to "fred", then remove that row.
I've tried this approach below, but no success.
Note: x="fred" and test is the array
Thank for your help.