Not sure what you are looking for. Do you want to query posts and only return posts with the subfield value? Or do you want to loop through the sub field and show only the rows that contain the value? Or are you trying to do both of these?
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users