Advanced Filter and PivotTable Combination?

[TSAConsultancy]

I am new to the MrExcel forum, so if this is covered someplace else, please forgive a newby.

My question has to do with trying to combine to Data functions in one table. In the data below there are duplicate records between the Customer No field and Item No field. I know this can be taken care of by running an Advanced Filter and selecting Unique Records. There are also variances in the Unit Price that I need to average. This can be done through a PivotTable. My issue is that I need to consolidate the unique records and average the Unit Price into a single line format (I need to match this data with add'l. fields in Filemaker Pro). Any advice or suggestions would be greatly appreciated!!

Customer No / Item No / Unit Price
20157 15090 $4.17
20157 15090 $4.13
20157 15090 $4.15
20157 15090 $4.12
20157 15090 $4.10
20157 20470 $8.00
20157 20570 $8.00
20157 20770 $10.00
20157 20770 $9.10
20157 20770 $10.20
20157 21782 $4.10
20157 22382 $0.95
20157 28982 $10.00
20157 30482 $4.10
20157 62291 $0.96
20157 62291 $0.93
20157 62291 $0.95
57331 33370 $19.95
57331 39770 $0.70
57331 50881 $3.35
57331 60791 $0.79
57331 60791 $0.81
57331 68671 $5.70
57331 05773 $2.56
57331 05773 $2.62
57331 05773 $2.70

 

[taigovinda]

Welcome to the board.

What should your output look like given the input in post #1, and how does it differ from a pivot table using 'average' instead of 'sum' ?

Tai