ZIP Code Sort

View previous topic View next topic Go down

ZIP Code Sort

Post  Diamondback Dave on 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...

Diamondback Dave
New

Posts : 771
Join date : 2009-05-29

View user profile

Back to top Go down

Re: ZIP Code Sort

Post  Darth Slurpee on 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.
avatar
Darth Slurpee
New

Posts : 798
Join date : 2013-11-11

View user profile

Back to top Go down

Re: ZIP Code Sort

Post  Diamondback Dave on 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.

Diamondback Dave
New

Posts : 771
Join date : 2009-05-29

View user profile

Back to top Go down

Re: ZIP Code Sort

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum