https://comicspriceguide.com/forum/messages.aspx?TopicID=6291 ComicsPriceGuide.com Forums - CPG - Questions and Answers - Viewing a list of my most valuable comics - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Mon, 03 Oct 2016 11:27:01 GMT Mon, 03 Oct 2016 11:27:01 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291 Mon, 03 Oct 2016 11:27:01 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291 Sun, 02 Oct 2016 19:10:45 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291
1. Go to your collection, where it is divided by publisher. You will have to do this separately for each publisher, or possibly copy together all of the separate spreadsheets.
2. Click on Raw to generate the download.
3. Retrieve your Excel file, open in Excel.
3.5 You may have to copy all of the data to a new sheet without formatting, to get rid of merged cells before trying to sort.
4. Add a new column down the left side. Use the Fill > Series function to number all of the rows 1 to whatever going down.
5. Now sort the columns by what should now be the "G" column, that has the individual issue values in it. Descending, if you want the highest ones at the top.
6. You may have to scroll down but you'll eventually find the highest dollar figures starting, and then they go downward.
7. For the books you are interested in, change the font color of the value field (or any number of fields on that row).
8. Go back and resort the entire list based on that first column, descending. This puts everything back in the original order.
9. Now you can scroll through and look for the items with the different font color.

3.75 (Optional) create all of your individual spreadsheets and copy paste them all into one, with each one below the other, where the fields all line up. This lets you get information from more than one publisher into one sort.

7.5 (Optional) Add a new field on the right side where you do another fill from 1 to whatever for the items that have dollar figures. Then, when you are finished, you will have a ranking of each book for its value in the collection.

CPG - if you could just do a version of the spreadsheet that repeats the title on each line, that would make this much much easier.]]> Tue, 13 Sep 2016 18:01:07 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291 .
edited by glennsim on 9/13/2016]]> Tue, 13 Sep 2016 17:08:29 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291
Aaron]]> Tue, 13 Sep 2016 09:44:10 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=6291 Mon, 12 Sep 2016 23:08:07 GMT