=COUNTIF(H16:H278,"*")-COUNTIF(H16:H278,"*stephen mcgowan*"+COUNTIF(H16:H278,"*stephen mcgowan*"/2))

I'm working with a column of different names and sometimes there will be the same name in 2 different cells. If there are 2 of same name in the column I need them to add up as 0.5 and single names to add up as 1