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.
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.
Last edited by jenya_utd; 02-06-2012 at 07:03 AM.
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.
Good luck.
sorry for the thread, OnErrorGoto0 it doesn't work =\
@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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
o.k it works, TNX!!!!!!!
You're welcome. Big thanks to OEG0 fo the actual FREQUENCY formula ... they're always a mystery to me.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks