this post was submitted on 13 Sep 2023
1535 points (98.9% liked)

Memes

45884 readers
1408 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 9 points 1 year ago* (last edited 1 year ago) (1 children)

Honestly, since the introduction of 'tables', pivot tables, Power Pivot and Power Query, Excel is way more viable to be used as a database. Tables in particular mean that formulas fill down and the range automically resizes when records are added.

[โ€“] [email protected] 4 points 1 year ago

Iirc tables are actually treated similar to databases on the backend.