hi
am traying to do a project and that project request from me to group my data
in a groups like this:
(data start at cell 16)
am traying to do a project and that project request from me to group my data
in a groups like this:
(data start at cell 16)
Code:
G H I J
k
data serial group max number reference
16 894 1 1
17 864 2 2
18 733 3 3
19 628 4 4
20 577 5 5
21 444 6 6
22 1368 7 7
23 1158 8 8
24 909 9 9
25 1156 10 10
26 1279 11 11
27 1174 12 12
28 920 13 13
29 708 14 14
30 668 15 15
31 734 16 16
32 450 17 17
33 687 18 1
34 749 19 2
35 502 20 3
36 401 21 4
37 657 22 5
38 566 23 6
39 769 24 7
40 873 25 8
41 792 26 9
42 642 27 10
43 422 28 11
44 788 29 12
45 654 30 13
46 458 31 14
47 1101 32 15
48 1115 33 16
49 1713 34 17
. . .
. . .
. . .
. . .
n n n 17
[code/]
my first problem is to numbering data in groups like in columen l "some time i
need to change the numbering insted of 17 i would like it to be 15" so how to start count from
1 to my desier number and then start agine to put 1 until 15 and etc....... ?
secound problem : within each group ( from 1 to 17 or 15 or what i want it to be)
how to find the max number? or min number in coulumn G?
third problem... l want to put the serial number for each max or min in coloumn
k (referec)
example : if my grouping is from 1 to 17 the max number of coloumn G (data)
within the first (1 to17) group is 1368 i will put it in coloumn j cell 22 and i will put it's reference
from colomn H (serial) which is (7) in coloumn k (reference) cell 22
and so on until the end of my data n
hope for some help in doing this because i have many data and doing this by hand
is very hard
and thanks in advance
