TrackDollar
Would you like to react to this message? Create an account in a few clicks or log in to continue.

ZIP Code Sort

2 posters

Go down

ZIP Code Sort Empty ZIP Code Sort

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

Diamondback Dave
New

Posts : 837
Join date : 2009-05-29

Back to top Go down

ZIP Code Sort Empty Re: ZIP Code Sort

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

Posts : 1024
Join date : 2013-11-11

Back to top Go down

ZIP Code Sort Empty Re: ZIP Code Sort

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

Diamondback Dave
New

Posts : 837
Join date : 2009-05-29

Back to top Go down

ZIP Code Sort Empty Re: ZIP Code Sort

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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