These people have trouble with VLOOKUP already (I mean the string/int problem is unintuitive, so I'm not talking about that), so this is an impossible task for them. In pure Power Query you can do this without too much trouble, but you need to know what you are doing. Like, they wanted tables from a shared folder appended on each other and joined to another table.
CLIPY THINGS FOR PUTTING THINGS TPOGETHER SOFTWARE
But I am a software dev with database experience, so I'm not sure who the target market is here-it's not the pure Excel users. M is pretty easy to learn so it wasn't a big deal for me. When I worked for a company where corporate used it, the problem was that people would come to me for help. You can then display these views on a sheet. You can combine tables from both your sheets and/or a variety of external sources and create relational views into them. In Excel Power Query and the M language are quite powerful. Even Access requires a decent amount of technical know-how when compared to the people who use Excel heavily.
"Easy" is tough when it comes to relational databases. You'll need to load Office 97 or some other ancient version in a VM if you want to actually try this, since Microsoft finally killed off Clippit completely in Office 2007. ' TODO make the user's choices actually do something Animation = msoAnimationGetAttentionMinor CheckBoxes(1).Text = "Don't show me this tip again" Labels(2).Text = "Just let me generate excessive technical debt without help" Labels(1).Text = "Get professional help" Text = "It looks like you're trying to implement a relational database in a spreadsheet." ' TODO I should probably do ".Mode = msoModeModeless" but I don't feel like writing a callback If InStr(Target.Formula, "VLOOKUP") = 0 Then ' TODO maybe respect some of the properties on Assistant to let the user disable this Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)
0 kommentar(er)
