I have the list given below

27
19
10
22
10
17
22
5
20
3
20
17
10
28
27
12
15
29
33
24
35
10
15
16
12
21
10
16
34
22
17
22
27
26
21
12
15
12
3
20
4
3
15
16
15
15
14
59
15
24
34
13
13
23
11
11
15
4
17
11
23
23
10
13
19
23
14
15
12
28
29
34
25
21
10
11
14
22
11
16
4
12
19
56
30
32
22
29
51
8
32
36
18
2
31
17
79
9
18
18

and i have to count the repeted values i.e
< 5 6 - 15 16 - 25 25 - 50 50 - 75 > 75
---------------------------------------------------------------------
8 ? ? ? ?
?


can any buddy help me to get the result Please ???

sanjay
(E-Mail Removed)

=COUNTIF(A:A,"<=15")-COUNTIF(A:A,"<=5")

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sanju" <(E-Mail Removed)> wrote in message
news:51D8B047-8D84-4F96-824D-(E-Mail Removed)...
> I have the list given below
>
> 27
> 19
> 10
> 22
> 10
> 17
> 22
> 5
> 20
> 3
> 20
> 17
> 10
> 28
> 27
> 12
> 15
> 29
> 33
> 24
> 35
> 10
> 15
> 16
> 12
> 21
> 10
> 16
> 34
> 22
> 17
> 22
> 27
> 26
> 21
> 12
> 15
> 12
> 3
> 20
> 4
> 3
> 15
> 16
> 15
> 15
> 14
> 59
> 15
> 24
> 34
> 13
> 13
> 23
> 11
> 11
> 15
> 4
> 17
> 11
> 23
> 23
> 10
> 13
> 19
> 23
> 14
> 15
> 12
> 28
> 29
> 34
> 25
> 21
> 10
> 11
> 14
> 22
> 11
> 16
> 4
> 12
> 19
> 56
> 30
> 32
> 22
> 29
> 51
> 8
> 32
> 36
> 18
> 2
> 31
> 17
> 79
> 9
> 18
> 18
>
> and i have to count the repeted values i.e
> < 5 6 - 15 16 - 25 25 - 50 50 - 75 > 75
> ---------------------------------------------------------------------
> 8 ? ? ? ?
> ?
>
>
> can any buddy help me to get the result Please ???
>
> sanjay
> (E-Mail Removed)