Consolidate values

[Assamita]

Hello everyone.
I'm having troubles with a huge file I'm trying to reduce.
I have a list of almost 280k sales orders that it's slowing the file (and the whole computer) down a lot. For my purposes, I realized I can reduce that drastically by summing up the number of orders per month, instead of having one line per each single order.
My original idea was to use the consolidate button, but I haven't figured out how to properly use it, so my second option was to add a columns with a sumifs formula, and then delete duplicates. But it takes so long the file finally crashes.

The values are looking something like:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]Vendor[/TD]
[TD]Sales order[/TD]
[TD]Full Date[/TD]
[TD]Month only[/TD]
[TD]Number of invoices[/TD]
[/TR]
</tbody>[/TABLE]

I would need to group by month the number of sales orders per country per vendor (I hope I made myself clear).

Any ideas on how can I do it?
Thank you

 

[jbesclapez]

Can you send the file? Because I dont think we can help otherwise... it's too theoretical your problem. Sorry

 

[Assamita]

well, it's an 18Mb file, and it has sensitive data in it (it's a work file), so I'm afraid I can't. But I can copy the headers and make up one line, see if that could help.

[TABLE="width: 1185"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Company code[/TD]
[TD] [/TD]
[TD]Global Manufacturer (MD)[/TD]
[TD]Local Manufacturer (MD)[/TD]
[TD]L- Prod Hierarchy (MD)[/TD]
[TD]Profit Center (MD)[/TD]
[TD]Sales document[/TD]
[TD]Sales order date[/TD]
[TD]No of invoices[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]0010[/TD]
[TD][/TD]
[TD]ACRONIS[/TD]
[TD]ACRONIS[/TD]
[TD]Acronis Lizenzen[/TD]
[TD]Acronis[/TD]
[TD]xxxxxxxxxxxx[/TD]
[TD]30/05/2017[/TD]
[TD]1[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[Assamita]

Nevermind, I left it working and I've managed to do it. It took about 2 hours of computer time, but it's ok now.
Thank you