vijaychennai
Board Regular
- Joined
- Dec 7, 2009
- Messages
- 239
Hello all,
I have excel file in the below format.
Answer :
Split :
I have excel file in the below format.
Excel Workbook | |||
---|---|---|---|
J | |||
1 | Rank | ||
2 | 10 | ||
3 | 10.5 | ||
4 | 30 | ||
5 | 72 | ||
6 | 90 | ||
Sheet1 |
Answer :
Excel Workbook | ||||
---|---|---|---|---|
J | K | |||
1 | Rank | Split | ||
2 | 10 | 8-10 Rank | ||
3 | 10.5 | 10-12 Rank | ||
4 | 30 | 28-30 Rank | ||
5 | 72 | 70-72 Rank | ||
6 | 90 | > 72 Rank | ||
Sheet1 |
Split :
Excel Workbook | |||||
---|---|---|---|---|---|
E | F | G | |||
1 | Start | Between | |||
2 | 0 | 2 | 0-2 Rank | ||
3 | 2 | 4 | 2-4 Rank | ||
4 | 4 | 6 | 4-6 Rank | ||
5 | 6 | 8 | 6-8 Rank | ||
6 | 8 | 10 | 8-10 Rank | ||
7 | 10 | 12 | 10-12 Rank | ||
8 | 12 | 14 | 12-14 Rank | ||
9 | 14 | 16 | 14-16 Rank | ||
10 | 16 | 18 | 16-18 Rank | ||
11 | 18 | 20 | 18-20 Rank | ||
12 | 20 | 22 | 20-22 Rank | ||
13 | 22 | 24 | 22-24 Rank | ||
14 | 24 | 26 | 24-26 Rank | ||
15 | 26 | 28 | 26-28 Rank | ||
16 | 28 | 30 | 28-30 Rank | ||
17 | 30 | 32 | 30-32 Rank | ||
18 | 32 | 34 | 32-34 Rank | ||
19 | 34 | 36 | 34-36 Rank | ||
20 | 36 | 38 | 36-38 Rank | ||
21 | 38 | 40 | 38-40 Rank | ||
22 | 40 | 42 | 40-42 Rank | ||
23 | 42 | 44 | 42-44 Rank | ||
24 | 44 | 46 | 44-46 Rank | ||
25 | 46 | 48 | 46-48 Rank | ||
26 | 48 | 50 | 48-50 Rank | ||
27 | 50 | 52 | 50-52 Rank | ||
28 | 52 | 54 | 52-54 Rank | ||
29 | 54 | 56 | 54-56 Rank | ||
30 | 56 | 58 | 56-58 Rank | ||
31 | 58 | 60 | 58-60 Rank | ||
32 | 60 | 62 | 60-62 Rank | ||
33 | 62 | 64 | 62-64 Rank | ||
34 | 64 | 66 | 64-66 Rank | ||
35 | 66 | 68 | 66-68 Rank | ||
36 | 68 | 70 | 68-70 Rank | ||
37 | 70 | 72 | 70-72 Rank | ||
38 | 72 | 1000000 | > 72 Rank | ||
Sheet1 |