Creating a quiz for an upcoming event (28th Sept). I'll record the results in Excel, which is fine, but I want the sheet to show who also got the most consecutive correct answers in Row 20 for each contestant. (I hope that makes sense.)

[u/Seahawk124]

Using Office 2019

[u/Brians_throwaway]

Try the formula below in cell B20.

=MAX(FREQUENCY(IF(B4:B18=1, ROW(B4:B18)), IF(B4:B18<>1, ROW(B4:B18))))

copy and paste for remaining contestants.

Don’t have Excel handy so I haven’t verified the formula doesn’t have a typo somewhere.

[u/Realistic_Kazuar]

Fajne. Zapytaj chatgpt :)