hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
I have data as follows being generated in 2 columns, column A & column B as below:
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>In column E4:E10, premium is to generated in increasing order.
Based on Age (as 0 to 20, 0 & 20 punched in different cells), Total number of premium has to be filled as below.
For no filling, null ("") is required.
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>
</TBODY>
How to accomplish?
Thanks in advance.
Age | Premium |
20 | 5000 |
56 | 4000 |
32 | 3000 |
45 | 2000 |
29 | 1000 |
35 | 2000 |
37 | 1000 |
48 | 5000 |
54 | 4000 |
78 | 3000 |
90 | 2000 |
1 | 1000 |
15 | 3000 |
33 | 2000 |
43 | 1000 |
75 | 5000 |
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>
Based on Age (as 0 to 20, 0 & 20 punched in different cells), Total number of premium has to be filled as below.
For no filling, null ("") is required.
Premium | Age | |||||||||
0 | 20 | 21 | 40 | 41 | 60 | 61 | 80 | 81 | 100 | |
1000 | 1 | 2 | 1 | |||||||
2000 | 2 | 1 | 1 | |||||||
3000 | 1 | 1 | 1 | |||||||
4000 | 2 | |||||||||
5000 | 1 | 1 | 1 |
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>
</TBODY>
How to accomplish?
Thanks in advance.