4 ms·

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. Proble

by chewxy 14y ago

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.

crazcarl 14y ago
I think danso's problem would also be solved by showing them pivot tables in Excel.
- cgio 14y ago
  sumifs || dsum an alternative too.
  - NamTaf 14y ago
    sumproduct rules my world when it comes to this.