Hacker News new | comments | show | ask | jobs | submit login

I faced this before. I have a solution: Open up PHPMyAdmin, show them how it looks like in a proper database.

Then show them how to lock panes in Excel. Problem pretty much solved.

I think danso's problem would also be solved by showing them pivot tables in Excel.

sumifs || dsum an alternative too.

sumproduct rules my world when it comes to this.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact