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)
<tbody>
</tbody>eg what price is listed in xxx for apple???
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>