Hello guys,
Need your help as i need to know listed (repeated price) price for apple sold in 120203
which excel formula shall i use? i have large database with different product and market code... [TABLE="width: 500"]
<tbody>[TR]
[TD] Product Code[/TD]
[TD]Product name[/TD]
[TD]price[/TD]
[TD]market code[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120202[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120201[/TD]
[/TR]
</tbody>[/TABLE]
Need your help as i need to know listed (repeated price) price for apple sold in 120203

<tbody>[TR]
[TD] Product Code[/TD]
[TD]Product name[/TD]
[TD]price[/TD]
[TD]market code[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120202[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120201[/TD]
[/TR]
</tbody>[/TABLE]