I am currently busy re-organizing my collection file and as I'm a statistics freak, I want to see every detail at a glance.
There are two ideas I have but I don't know how to realize them.
I want to count all of my magazines. Here's a screenshot of what it looks like:
I'd like to have the program count the amount of cells with content in a specified area. For instance, to calculate the number of magazines in the screenshot above, a command that calculates the number of cells w/content between C and N and 2 up to 25 would be exactly what I need.
The second command I'm looking for is to distinguish the number of games per region. Beneath is an excerpt of my PS2 collection:
The command I need would need to count the amount of jp's, us's and pal's in a specified area, for instance "B2:B26".
Any help is appreciated! :thumbsup: