View Single Post
Old 12-22-2008, 12:53 PM   #56
astrodad
Guru
astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.astrodad ought to be getting tired of karma fortunes by now.
 
astrodad's Avatar
 
Posts: 962
Karma: 568242
Join Date: Dec 2007
Device: Kindle Oasis 3, Kindle Paperwhite 1, iPad, iPhone
I went through to see how many I had read, but it was taking too long to count. To solve this problem, I created a new column to count the number of times the word YES appeared in a the 'Read' Column using the following formula:

=COUNTIF(C2:C1001,"=YES") where column C is a column called 'Read?'

It's just a simple way to count the number I've read. I've since redacted your original list and started to add my own contents.

Thanks for the head start!
astrodad is offline   Reply With Quote