https://issues.apache.org/ooo/show_bug.cgi?id=122358

--- Comment #5 from Edwin Sharp <[email protected]> ---
(In reply to Rob Weir from comment #4)
> COUNTIF is not case sensitive, so the formula is finding cases of 'me' as
> well.
> 
> There is a trick to get a case-sensitive count, by using this formula in D2:
> 
> =SUMPRODUCT($C$2:$C$794=C2)

Thank you!
This valuable information should be in the help.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

Reply via email to