Hi anybody help me. i hv data. i can use auto filter
I want if i am enter any value in E1 (Marks), the auto filter automatic
reflict in Marks Column (C)

Row A B C D E ----------Column
1 Sno Name Marks 50
2 1 aa 50
3 2 bb 66
4 3 cc 78
5 4 dd 49
6 5 ee 58
7 6 ff 35
8 7 gg 26
9 8 hh 50
10 9 ii 59
11 10 jj 60
12 11 kk 45
13 12 ll 50
14 13 mm 66
15 14 nn 78
16 15 oo 79
17 16 pp 35
18 17 qq 26
19 18 rr 59
20 19 ss 79

Output - which i want

When I am enter value in Marks(E1) =50 the its filter automatically this
type
Row A B C D E ----------column
1 Sno Name Marks 50
2 1 aa 50
9 8 hh 50
13 12 ll 50

PL help me urgently
RKS