3 ms·

Excel has named ranges. You can name any single cell, row, column, 2d array.

• codesnik 6y ago
  But they're pain in the ass to use, modify, and really feel as an afterthought which barely used by anyone. Compare this to "Numbers": you just enter any text int row or column header and this text is immediately usable and visible as a range specifier in formulas. How intuitive is that? Also excel has (inner) tables inside of tables, with more restrictions that. Also excel even has SQL-dialect for querying columns. That's not important, important are defaults, and how your simple spreadsheet you can fit into a screen is going to evolve. Excel makes it VERY hard to not make a mess, even if you have time to learn it.
  • rvba 6y ago
    You talk about SQL being great, yet you probably never had to download data from tables where the headers are German abbreviations, or gibberish due to 8 character limit in 1985.
    • codesnik 6y ago
      SQL is greatER than excel's default mode of addressing data. As russian, I've worked with a very diverse data sources in different encodings during my career, fair amount of broken CSV's, xml's, etc, cleanups, joins, sqlite processing etc. And yes, many, many excel files used as a poor man's data entry software to cleanup. No german abbreviations, right, just poorly made russian transliterations.