G'day!
I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1))
It batches column A with re-occurring values and gives the number of batches this works great!
However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B.
See example below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]sg[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]sg[/TD]
[/TR]
[TR]
[TD]3800[/TD]
[TD]hr[/TD]
[/TR]
</tbody>[/TABLE]
The solution would be to obtain the answer 2. As 1000 batch contain mg and 1500 contain mg.
Any ideas would be great.
Thanks all.
Luke
I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1))
It batches column A with re-occurring values and gives the number of batches this works great!
However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B.
See example below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]sg[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD]mg[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]sg[/TD]
[/TR]
[TR]
[TD]3800[/TD]
[TD]hr[/TD]
[/TR]
</tbody>[/TABLE]
The solution would be to obtain the answer 2. As 1000 batch contain mg and 1500 contain mg.
Any ideas would be great.
Thanks all.
Luke