Forum Discussion

Brass Contributor

Aug 21, 2023

Solved

count consecutive occurrences if multiple criteria

I am counting times a value appears consecutive but i need it to only count if multiple criteria met. for example below i counting times "mike" appears consecutively. but i want "mike" along with mat...

excel

Formulas and Functions

rangelsammon
Aug 22, 2023
solved what i wanted. posting response in case someone wants
=FREQUENCY(IF(C2:C9="mike",IF(D2:D9<>1.5,ROW(C2:C9))),IF(C2:C9<>"mike",IF(D2:D9=1.5,ROW(C2:C9))))

rangelsammon

Brass Contributor

Aug 22, 2023

solved what i wanted. posting response in case someone wants
=FREQUENCY(IF(C2:C9="mike",IF(D2:D9<>1.5,ROW(C2:C9))),IF(C2:C9<>"mike",IF(D2:D9=1.5,ROW(C2:C9))))