How to do your Cohorts analysis in Spreadsheet & Excel (A detailed guide)
8 min readDec 27, 2016
Since my daily grind is filled with spinning excel tables, I decided to gift myself with a headache this Christmas: I exported user’s emails and purchase dates so that I could build my cohorts and glean some other useful insights. I soon became stuck on which formula to use, how to write my IF statements, running into cyclical redundancies, and being jammed by…