Hacker News Reader

winphone1974

"Several tables and selectively joining them" ... "Enter an id and filter"

Sure sounds like your creating a relational database in a spreadsheet, which is possible but not really the intended purpose?

View on HN

Surely that's what lots of non-developer white collar workers use Excel for? I imagine there's orders of magnitude more people using Excel for data processing rather than Python or R. I'm well aware it's not the best tool for the job, but yet people are using it for purposes such as that. I wanted to learn more about that experience.

I think no. Most people don't do table joins very often. They wouldn't know how. What they'll do instead is create lookups with VLOOKUP or INDEX(MATCH()) to pull in values from other tables into their one master. And once they have the master flat file they'll use a pivot table for group by aggregations.

This is very accurate in my experience, down to the suggested formulas.

Reply on news.ycombinator.com