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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks