Hi Vletm,
Yes, no one will change the old data, so I ended up deciding to split the data by year (each file was about 40,000 lines).
As for speed, I had already tried to use the PivotTable, but it still slowed down, the screen faded, excel did not respond, so I started to use formula...