Thursday, January 18, 2018

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

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.