I have a reading list set up, title, number in series, Author, format, genre, when it was finished.
What I'm trying to do is have a title display randomly for books that have not been read, and that are the first in their series which will have a 1 in the # column. (They'll have a 1 in the # column, even if they are stand alones). For those times when I want to read but I'm not in the mood to sort through my list and pick one. This will do it for me.
This is the code i'm using currently =IF(AND(B2=1,ISBLANK(F2)),A2,IF(AND(B2>1,ISBLANK(F2)),"not yet", "You've read it")) to sort out the titles
This is what I'm using to generate the title which is drawing from Column H where the books are sorted =IF(OR(H:H="you've read it",H:H="not yet"), INDEX($H:$H,RANDBETWEEN(1,COUNTA($H:$H)),1),"")
I'm probably over complacating this.
Bookmarks