Thread: help with a FREQUENCY function

i looking for a function to count the number of times that some string apear in a sequence
for example if this is my table

A1 - w
A2 -w
A3 -w
A4 -d
A5 - l
A6 - w
A7 - w
A9 -d
etc..
i want for the function to show me the number 3.

Hello
Try
=MAX(FREQUENCY(IF(A1:A9="w",ROW(A1:A9)),IF(A1:A9<>"w",ROW(A1:A9))))

array entered by pressing Ctrl+Shift+Enter and not just Enter.

@jenya-utd: works for me. At least, it returns a 3. Did you use Ctrl-Shift-Enter to commit the formula rather than just Enter?

You will see:

{=MAX(FREQUENCY(IF(A1:A9="w",ROW(A1:A9)),IF(A1:A9<>"w",ROW(A1:A9))))}

if you have done it correctly.


Regards, TMS

You're welcome. Big thanks to OEG0 fo the actual FREQUENCY formula ... they're always a mystery to me.

Regards, TMS