3 ms·
1. Some sort of toggle somewhere for dates before 1900 being supported just like dates after 1900. I work with a lot of historical baseball data with dates bef
by Balgair 4y ago
1. Some sort of toggle somewhere for dates before 1900 being supported just like dates after 1900.
I work with a lot of historical baseball data with dates before 1900. Constantly having to do string conversions to math and then back again is so tiring. Every time I port in data, I have to clean it up, and every time it screws up in some new and novel way.
Yes, I'm aware that XL's date automatic date conversion causes havoc in genetic data sets as is. And yes, I know that it would cause further havoc if pre-1900 dates were automatically seen as dates.
But some toggle somewhere that I could just click once and then be done with it would save me weeks of time.
2. Again, another toggle that keeps acutes, tildes, and other letters as separate from their non-marked twins when sorting alphabetically or otherwise processing data.
Currently when I sort baseball players by name, alphabetically, the 'á' and 'a' or 'ñ' and 'n' are seen as the same letter and sorted intermixed. This is a huge problem when dealing with Central American, South American, and Caribbean players. Common names like José are not the same as Jose. Same goes for string comprehension functions or searching.