The standard detect-duplicates formula has a possible bug?

[Philster]

Hi, all

I normally use the detect-duplicates functions that have been provided in this forum many times over. However, I think that I may have found a bug, and I would like somebody else to verify if I'm correct or not.

Attached is one of my work spreadsheets, stripped down to small size. These spreadsheets normally highlight duplicate cells in column C9:10. There is also a summary duplicate-detection cell C5 for long spreadsheets. Offset is used only because different spreadsheets may have varying numbers of header rows, and varying numbers of detail rows.

These formulas normally work fine. I suspect the bug may be because this particular spreadsheet's column C details cells contains an IF statement.

Did I find a bug?

[shg]

COUNTIF interprets the asterisk as a wildcard character.

[Philster]

Thank you, SHG