ZIP Code Sort
2 posters
TrackDollar :: user :: Help
Page 1 of 1
ZIP Code Sort
Hello Markus,
Was wondering if you could possibly make the ZIP code entry section sort-able? I would like to check my ZIP codes and make sure I have them all on my spreadsheet, but it currently only sorts by amount entered in each ZIP code, so this task is impossible to do. If I could sort by ZIP code instead, I would be able to have it listed the way I have it on my spreadsheet.
Thanks and hope all is well, haven't seen ya in a while...
Was wondering if you could possibly make the ZIP code entry section sort-able? I would like to check my ZIP codes and make sure I have them all on my spreadsheet, but it currently only sorts by amount entered in each ZIP code, so this task is impossible to do. If I could sort by ZIP code instead, I would be able to have it listed the way I have it on my spreadsheet.
Thanks and hope all is well, haven't seen ya in a while...
Diamondback Dave- New
- Posts : 837
Join date : 2009-05-29
Re: ZIP Code Sort
I don't disagree with the request.
What I do is simply copy the entirety of the Bill report - ZIP Code section from the My Bill Summary page, paste it into Excel, and then sort. I did this just this week to do an update to my traveling pages I carry with me so I can see the ZIPs in which I've entered bills and how many I've entered (blacking out the ones that have an awesome Hits/Entries rate that I don't want to ruin with new entries ).
Depending on how you have your tracker spreadsheet set up, you can even use Excel's Remove Duplicates feature to get to your desired end state.
And still yes, it would be nice to be able to sort on our entered ZIPs.
What I do is simply copy the entirety of the Bill report - ZIP Code section from the My Bill Summary page, paste it into Excel, and then sort. I did this just this week to do an update to my traveling pages I carry with me so I can see the ZIPs in which I've entered bills and how many I've entered (blacking out the ones that have an awesome Hits/Entries rate that I don't want to ruin with new entries ).
Depending on how you have your tracker spreadsheet set up, you can even use Excel's Remove Duplicates feature to get to your desired end state.
And still yes, it would be nice to be able to sort on our entered ZIPs.
Darth Slurpee- New
- Posts : 1024
Join date : 2013-11-11
Re: ZIP Code Sort
Not a bad idea, wish I would have seen it before I embarked on my conquest.
So, as stated above, not really impossible, but took some time. Will try the excel way next time. Thanks Darth.
So, as stated above, not really impossible, but took some time. Will try the excel way next time. Thanks Darth.
Diamondback Dave- New
- Posts : 837
Join date : 2009-05-29
Similar topics
» Canadian Zip Code Fix, Please!!
» Outages Only
» Re-Sort the Achievements
» DC Zip Code Map
» Anagrams.. A programming dilemma.
» Outages Only
» Re-Sort the Achievements
» DC Zip Code Map
» Anagrams.. A programming dilemma.
TrackDollar :: user :: Help
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum