General Forum

So I have decided to start listing my cards as a backup to the site using Excel.  I am pretty decent with basic functions in Excel, and I often use it at work.  I have a question about sorting though.  I don’t want to have a huge list of cards and then completely mess the whole thing up.  

I am thinking about having 3 columns to keep it very simple.  I will add column 3 and 4 for notes for VARs if necessary.  But mainly I will have set, number, and name.  I will have a filter option set for each header.  

Now, I know I can click on that filter button and have Excel sort all those rows Alpha by set if I choose that option on the set filter.  But, I also want to always make sure the numbers for each set are in order as well- especially for adding new cards in the future. 

Now, I don’t really understand how the logic in Excel works.  I’m pretty dumb when it comes to computers, especially for someone my age.  

But here is my theory, can anyone tell me if I am correct?  If I have the 3 columns labeled with a filtered header for set, number, and name, and add new cards to the bottom of the sheet- can I just first expanded sort the numbers column from lowest to highest, and then expanded sort the sets column from a-z?   Will this put all my sets in order from a-z with the cards being on correct numbered order on the spreadsheet?  I think that 2 steps will always work but I’m not completely sure.  The goal is just to have all my cards in order by set and number from A to Z and in numerical order.  Any tips for a computer flunky?

I was going to PM you, but it appears you have that feature turned off. I am pretty good with Excel, and I've read that last paragraph 3 times and can't figure out what you're asking.

I'll offer this - if you go into Custom Sort, there, you'll be able to do "multi-level" sorting. That is, sort by Column G, then sort by Column C, then sort by Column J. This might answer those questions.

Hi Dan, yeah I turned off my messaging for a little while.  Kind of taking a bit of a break from the hobby right now.  Was going to focus on making a backup sheet that I can slowly work on. Yeah, i figured my post is kind of wordy and jumbled.  I may need to test the custom sort like you mentioned. 

I guess I am just wondering if I have my cards listed in each row by set, number, and name, if I first sort the numbers column from lowest to highest, and then sort the set column from A to Z, will I end up with my cards in order by set name and all the cards listed in each set in numbered order? Or will the numbers gets jumbled again when I do the second sort? 

After addding the new cards in the columns you can always remove the filter then add it back on.  If you don't have any blank rows it should add the new rows.

Drop me a msg with your email and I can send you a copy of my checklist that I use for you to look at and see if u like it

Yes to your question. Now the question I have for you is are you using the Filter option which would put the down arrow in each column?

You don't need a filter or column header. Use the sort feature and add multiple rows, you can sort it by set, card number, player name, whatever, and it will put it in whatever order you choose, and can be changed with just a couple clicks. My overall chart I sent you the sceencap of also had an overall number so I could also sort it back into the original order of entry as well. 

Hint: click the little square with nothing in it at the top left convergence of column 1 and row 1. It will highlight the whole sheet. If you must use s header remember to click the "my data has headers" option when you sort of else your header will get mixed into the chart based on the sort parameters you choose.

After screwing my PC up several times.  I have a test sheet that I copy my PC to and do all my sorting there.    After the sorting and what I was doing I can go back to my main sheet.    It has been helpful and when you sort (say by name ) you find misspelled word and missiing boxes.

Thanks everyone for your advice and suggestions.  I was messing around with Excel today and I was able to perform the multi level sort.  I didn’t know this function was possible.

Although I was able to get that to work, I started feeling a little overwhelmed from the whole thing and I think I’m just going to continue to rely solely on the TCDB.  Hopefully this site continues on and lasts forever. 

I have been feeling a bit overwhelmed from the hobby in general recently and I’m not really sure why.  Just really hard to find the time for it right now and I’m getting a little burned out I guess.  I’ll still be on the forums here I’m sure and tracking my collection, but I may be less active for a while.

Thanks again everyone. 

Fwiw, I enjoy your posts and responses.  I understand the organization issues and hope you continue