yogi_Compute Row By Row Running Count OF Genres Read By Name

Google Spreadsheet   Post  #2347

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-18-2018

question by: Mike Wielgus

https://productforums.google.com/forum/#!topic/docs/MAOBOsBw-Pg;context-place=mydiscussions

Counting Unique Book Genres Per Student Form Submission

I am trying to keep a running total of unique book genres that students read.

Students will fill out a Google Form and for each submission that has a unique genre, I'd like the cell in the sheet to increase.

So, the first unique genre's cell would read 1, the second unique genre's cell would read 2.

When a different student submits, it would count that student's unique genre starting at 1 and increase with each new submitted genre.

Can anyone out there assist?

Here's a link to the Google Sheet.

https://docs.google.com/spreadsheets/d/1d-DYW2cTsNhvPuwCjqWRwTeoUhdUoS2OiHszAjMq5kY/edit#gid=361458343

Thanks,

Mike