1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula to keep track of "Streak"

Summary of my problem below:

I ran a simple COUNTIF formula to keep track of correct and incorrect picks, 1 for correct pick and 0 for incorrect pick. The issue I am running into is keeping track of scoring...

The series of COUNTIF formulas exist in E46:E65, with a number of columns to the right tracking the same thing for different entries. The predetermined multipliers based upon the length of the streak exist in C25:C44.

For each consecutive instance of a "1", the multiplier moves down to the next value, but at the first instance of a "0" the score is 0, and the multiplier is reset - the next "1" would be multiplied by the value in C25.

Other than a very very long sequence of embedded IF formulas, I am out of ideas. What formula could point me in the right direction?

submitted by /u/T8rady12
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#COUNTIF
#formula
#correct picks
#incorrect picks
#scoring
#multiplier
#streak
#values
#E46:E65
#C25:C44
#instance
#embedded IF