Count occurences (Calc)

Uit De Vliegende Brigade
Naar navigatie springen Naar zoeken springen
This command in action + sorted for the column with the formula. I had to use $ around the cell references to avoid some slight complications - Works swimmingly

Pretty cool:

=COUNTIF(A2:A147; A2)

this will count how many times the value in A2 occurs in the colum from A2 to A147.