You have 1 wish...
You're viewing a single thread.
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.
Iirc tables are actually treated similar to databases on the backend.