Can you add a condition to a Max frequency formula or do the rows have to be consecutive for it to work please? I'm suspecting the latter.
I've got this array formula that works
=MAX(FREQUENCY(IF(ALL!$J$2:$J$5400="W",ROW(ALL!$J$2:$J$5400)),IF(ALL!$J$2:$J$5400<>"W",ROW(ALL!$J$2:$J$5400))))
then I added a further condition and it doesn't, well at least not with the correct result..
=MAX(FREQUENCY(IF(ALL!$E$2:$E$5400="H",ALL!$J$2:$J$5400="W",ROW(ALL!$J$2:$J$5400)),IF(ALL!$J$2:$J$5400<>"W",ROW(ALL!$J$2:$J$5400))))
Bookmarks