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

Search: