Code:
Hi Team,
I am looking for vba syntax here to count visible cells after filtering data
Status column should be unmatched, below are Criteria.
1) Count trade age less than <2 , Result Sheet2.range("b5")
2) Count Greater than >2 & <=3 , sheet2.range("b6")
3) Count Greater than >3 , sheet2.range("b7")
[TABLE="width: 256"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD][B]A[/B][/TD]
[TD][B]B[/B][/TD]
[TD][B]C[/B][/TD]
[/TR]
[TR]
[TD]Trade id[/TD]
[TD]Age[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]16174[/TD]
[TD]2[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16590[/TD]
[TD]3[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16337[/TD]
[TD]4[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16844[/TD]
[TD]5[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16017[/TD]
[TD]2[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16193[/TD]
[TD]2[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16345[/TD]
[TD]1[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16224[/TD]
[TD]0[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16757[/TD]
[TD]4[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16415[/TD]
[TD]1[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16553[/TD]
[TD]1[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16314[/TD]
[TD]4[/TD]
[TD]Matched[/TD]
[/TR]
[TR]
[TD]16096[/TD]
[TD]5[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16922[/TD]
[TD]1[/TD]
[TD]Unmatched[/TD]
[/TR]
[TR]
[TD]16501[/TD]
[TD]4[/TD]
[TD]Matched[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
Thanks in advance!
Thanks
Mallesh.