Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Quixzlizx
Jan 7, 2007
Is there any way to map individual pins/data points by zip code using Excel, rather than a filled/heat map?

I also tried using PBI, but there's a limit of objects that can be mapped, so PBI ends up leaving half the map blank.

It's frustrating that I can't seem to figure out how to replicate basic Microsoft MapPoint functionality.

Adbot
ADBOT LOVES YOU

Quixzlizx
Jan 7, 2007
Is there any way to make Google Sheets "remember" the last sort done on a sheet like the Excel behavior? The frustration of this not happening is multiplied by Sheets' UI being worse/slower than Excel's, with no keyboard shortcuts listed, no quick command bar, and having to add each column after the first in the sort interface instead of defaulting to having 3 present.

I know the SORT function exists, but I don't really want to need to duplicate the sheet and have to unhide/rehide the data source sheet every time just to work around this.

Edit: My solution ended up being to create a macro, since I always want to sort the sheet by the same criteria.

Quixzlizx fucked around with this message at 22:12 on Apr 27, 2024

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply