Is there a way to ensure the COUNTIF function takes these cell values as string parameters without doing an implicit cast?
有办法确保COUNTIF函数将这些单元格的值作为字符串参数不做隐式转换？
2
It also doesn't seem to matter what format my hex column is - the COUNTIF function always interprets these values as Numbers and therefore they appear as duplicates.