I've got data like this below.
All the weights are supposed to be consistent. So for example all 3 pound weights are supposed to be $5, regardless of province. But there could be an error somewhere, such as in the last line.
Is there a way to simply find all the difference prices for each weight? At the moment I'm filtering the Weight column and going through each bucket one by one, which kinda works. But with 50 buckets it's not the easiest way.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Prov[/TD]
[TD]Weight[/TD]
[TD]Price[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ON[/TD]
[TD]3[/TD]
[TD]$5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ON[/TD]
[TD]5[/TD]
[TD]$10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQ[/TD]
[TD]3[/TD]
[TD]$5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQ[/TD]
[TD]5[/TD]
[TD]$10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BC[/TD]
[TD]3[/TD]
[TD]$15[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
All the weights are supposed to be consistent. So for example all 3 pound weights are supposed to be $5, regardless of province. But there could be an error somewhere, such as in the last line.
Is there a way to simply find all the difference prices for each weight? At the moment I'm filtering the Weight column and going through each bucket one by one, which kinda works. But with 50 buckets it's not the easiest way.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Prov[/TD]
[TD]Weight[/TD]
[TD]Price[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ON[/TD]
[TD]3[/TD]
[TD]$5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ON[/TD]
[TD]5[/TD]
[TD]$10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQ[/TD]
[TD]3[/TD]
[TD]$5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PQ[/TD]
[TD]5[/TD]
[TD]$10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BC[/TD]
[TD]3[/TD]
[TD]$15[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]