Cell contains like this:
B5 No
B6 1
B7 =SUBTOTAL(2,$B$5:$B6)
B8 =SUBTOTAL(2,$B$5:$B7)
B9 =SUBTOTAL(2,$B$5:$B8)
B10 =SUBTOTAL(2,$B$5:$B9)
B11 =SUBTOTAL(2,$B$5:$B10)
B12 =SUBTOTAL(2,$B$5:$B11)
B13 =SUBTOTAL(2,$B$5:$B12)
B14 =SUBTOTAL(2,$B$5:$B13)
B15 =SUBTOTAL(2,$B$5:$B14)
B16 =SUBTOTAL(2,$B$5:$B15)
C5 Month
C6 Apr
C7 Apr
C8 May
C9 May
C10 Jun
C11 Jun
C12 Jul
C13 Jul
C14 Aug
C15 Aug
C16 Aug
Ok, now create Data filter for range "B5:C16"
and the do Text Filter in column C for "Apr"
and see what happen, it gives me wrong result, because the result including month of "Aug"!
this is what i got:
No Month
1 Apr
1 Apr
1 Aug
is it weird, what's wrong here?
B5 No
B6 1
B7 =SUBTOTAL(2,$B$5:$B6)
B8 =SUBTOTAL(2,$B$5:$B7)
B9 =SUBTOTAL(2,$B$5:$B8)
B10 =SUBTOTAL(2,$B$5:$B9)
B11 =SUBTOTAL(2,$B$5:$B10)
B12 =SUBTOTAL(2,$B$5:$B11)
B13 =SUBTOTAL(2,$B$5:$B12)
B14 =SUBTOTAL(2,$B$5:$B13)
B15 =SUBTOTAL(2,$B$5:$B14)
B16 =SUBTOTAL(2,$B$5:$B15)
C5 Month
C6 Apr
C7 Apr
C8 May
C9 May
C10 Jun
C11 Jun
C12 Jul
C13 Jul
C14 Aug
C15 Aug
C16 Aug
Ok, now create Data filter for range "B5:C16"
and the do Text Filter in column C for "Apr"
and see what happen, it gives me wrong result, because the result including month of "Aug"!
this is what i got:
No Month
1 Apr
1 Apr
1 Aug
is it weird, what's wrong here?