Shouldn't the Refusal Number (H4) be this:

=COUNTIFS(D$4:D4,D4,G$4:G4,"No")

which will maintain a count of No for each individual name ? Then in column I you can just look for column H being 6 or more.

Hope this helps.

Pete