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)

Customer code	Product name	Product code	Price	customer name
001	Apple	1008	2.00	xxx
002	Orange	1007	5.00	aaa
001	Apple	1008	2.00	xxx
001	Apple	1008	3.00	xxx

<tbody>
</tbody>

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