Find Duplicate value using multiple criteria

[jibu08]

Good day
Need your help as i can not figure which excel formula to apply!
I have large database with different customer and Product respective of their code and name, i need to find price(repeated ones)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer code[/TD]
[TD]Product name[/TD]
[TD]Product code[/TD]
[TD]Price[/TD]
[TD]customer name[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Apple[/TD]
[TD]1008[/TD]
[TD]2.00[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Orange[/TD]
[TD]1007[/TD]
[TD]5.00[/TD]
[TD]aaa[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Apple[/TD]
[TD]1008[/TD]
[TD]2.00[/TD]
[TD]xxx[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Apple[/TD]
[TD]1008[/TD]
[TD]3.00[/TD]
[TD]xxx[/TD]
[/TR]
</tbody>[/TABLE]
eg what price is listed in xxx for apple???

 

[James006]

Hello,

With a large database, you should Insert a Pivot Table ...:wink:

Hope this will help