Deposited in this blog are snippets of technical knowledge i'd like to refer back to from time to time.
Saturday, February 23, 2008
Counting the incidence of a name
In OpenOffice spreadsheet, suppose I want to count how many times a name appears, I found that one can use the countif function with the following syntax:
=countif( <range of cells to look at>;"="&<pattern>)
can be
"Name" or a cell such as F65.
Caveat: This function is very strict with pattern matching. A space at the end of the name will result in no match so be careful.
No comments:
Post a Comment