ZIP Code Sort

Diamondback Dave Sun Mar 19, 2017 2:39 pm

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...

Darth Slurpee Fri Mar 24, 2017 12:32 pm

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 Wink

).

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.

Diamondback Dave Sun Mar 26, 2017 9:58 pm

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.

Sponsored content

ZIP Code Sort

ZIP Code Sort

Re: ZIP Code Sort

Re: ZIP Code Sort

Re: ZIP Code Sort