›

The Backloggery Thread

2»

Comments

  • RetroVortexRetroVortex
    edited April 2012
    Not doing a new backloggery now.

    Just.. too many games!

    Can't process them all.
  • GuruGuru214GuruGuru214
    edited April 2012
    Darth Marsden wrote: »
    Eh, all I'm after is an basic 'X number of cells have a font colour of Y' count. Not after anything fancy. Also, it's not exactly essential. I know it won't be that big a number.

    And here's the code I've used to calculate the number of games in each column (the purple circle):

    Ah. To my knowledge, there's no way to have Excel base calculations on formatting.

    In my sheet, I use a separate column for whether or not a game is beaten, and conditional formatting (which I don't think your version of Excel can do) to automatically handle the color, so I just have to type "Yes" and "No" to get the results I want without having to mess with formatting. Then, to handle the counting, I use this:
    =COUNTIF(H:H,"Yes")
=COUNTIF(H:H,"No")
=COUNTIF(H:H,"In Progress")
=COUNTIF(H:H,"N/A")
  • Chyron8472Chyron8472
    edited February 2013
    Just updated my Backloggery.

    159 unfinished games. Dang.




    EDIT: Oops. Need to update my Wii/PS3 games. I'll do that later.
  • Chyron8472Chyron8472
    edited July 2013
    gZIs6zc.png

    This is all very true. :D
  • der_ketzerder_ketzer
    edited July 2013
    Chyron8472 wrote: »
    This is all very true. :D

    No. It's just not for you. But hey. At least it's cheap. And the 100 hours of it I played is enough for both of us.
  • Gman5852Gman5852
    edited July 2013
    Chyron8472 wrote: »
    This is all very true. :D

    I remember when I accepted opinions as facts!
Sign in to comment in this discussion.