3 ms·
I'll also mention excel now supports models, for proper table relations, avoiding the INDEX/MATCH function nonsense.
by Chris2048 10y ago
I'll also mention excel now supports models, for proper table relations, avoiding the INDEX/MATCH function nonsense.
- deleted 10y ago[deleted]
- derefr 10y agoHuh; never heart about this! Is there a good walkthrough of this functionality for people who already work with relational databases and just want a compare-and-contrast?
- Chris2048 10y agoNot sure, although MS has a few tutorials https://support.office.com/en-ie/article/Create-a-Data-Model-in-Excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b https://support.office.com/en-ie/article/Create-a-Data-Model...