Massive Data Sort (I'm Stuck)

[Dai Makka]

Hello All,

I need to sort thousands of lines of data as follows ;

Column A has codes ie MM060
Column D has order no's ie BM/124175
Column F has a costs ie 123.44


There are multiple lines with the same Code and Order No. all with different costs.

I'm looking for a way to sort the list so i can get a total cost for all the lines that match.

Currently I'm using manual filters which is taking ages.

Any help welcome.

Thanks

 

[Richard Schollar]

Hi

Have you tried using a pivot table? It would seem to be the perfect solution to your problem.

This link contains a useful intro to Pivot Tables if you haven't used them before:

http://www.contextures.com/xlPivot01.html